procedure error

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

procedure error

Postby amathew » Mon Jul 22, 2013 6:22 am

hi there,

i have the following procedure in my 10gR2 database.
Code: Select all
CREATE OR REPLACE  PROCEDURE "XYZ"."REFRESHDATA"  ("" in
    char)
Is
Begin
   Rollback;
End;


This is valid/working in 10g database. But when we exported/imported this procedure into 11g R2 database, it gives the below error message and cannot be compiled.

Code: Select all
Line # = 1 Column # = 37 Error Text = PLS-00182: Identifier cannot be an empty string


kindly help,
AM
AM
amathew
Senior Member
 
Posts: 213
Joined: Thu Dec 02, 2004 5:50 am

Re: procedure error

Postby Tim... » Mon Jul 22, 2013 7:53 am

Hi.

Seriously? Why would you do something like that? IMHO it should never have worked in 10g.

There is nothing to help here. You were doing something silly and now you can't. Looks to me like Oracle have just tightened up the compile to stop people doing silly things.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: procedure error

Postby amathew » Mon Jul 22, 2013 8:07 am

ok thanks Tim,

We were moving the vendor database from 10g to 11g. I have no clue what this procedure does.

thanks again,
AM
AM
amathew
Senior Member
 
Posts: 213
Joined: Thu Dec 02, 2004 5:50 am

Re: procedure error

Postby Tim... » Mon Jul 22, 2013 8:16 am

Hi.

OK. I suggest you go back to the vendor and ask them to fix it. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 5 guests

cron