ORA-00931: missing Identifier when testing/describing a Procedure under a Package.

[bciwmac]

Hello,
We have Developers that now have a numeric user id (00006423), instead of a character id (BCPWING). When we try to access the procedure, we get the ORA-00931: missing identifier. I know this happens in a telnet session connecting to the database, however, if we put double (") quotes around the user id, it will work.

Please see the 3 examples below. When we use 00006423 (without quotes), we get the error. We then used a different schema (BCPWING) and it works. So, we put quotes around the numeric ID ("00006423") and it works.

BCIST>desc 00006423.P_truncate_table
ERROR:
ORA-00931: missing identifier

BCIST>desc bcpwing.P_truncate_table
PROCEDURE bcpwing.P_truncate_table
Argument Name Type In/Out Default?
---------------------------- ----------------------- ------ ------
A_TABLE_NAME VARCHAR2 IN

BCIST>desc "00006423".P_truncate_table
PROCEDURE "00006423".P_truncate_table
Argument Name Type In/Out Default?
---------------------------- ----------------------- ------ ------
A_TABLE_NAME VARCHAR2 IN

Is there anyway to allow PL/SQL Developer to put double quotes around the User ID when we are trying to access any objects within the GUI interface. We can work around this in a Telnet session.

Thank you,
Ian

 

[Marco Kalter]

There is currently no option for this, but we'll improve this for the next release.

 

[bciwmac]

Hi Marco,

Thank you for the quick reply. Do you have an idea if this will be in the next patch set for version 13? Or will it wait for version 14?

Thanks again,
Ian

 

[Marco Kalter]

It will probably be included in 14.0.