SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00114: identifier too long error (Oracle 10g)

639485Mar 23 2009 — edited Mar 23 2009

Hi All,
Hi All,

I have created procedure called "p_procedure_for_cals_annual_sal_oracle_proprierty.lib".
It is must to give the procedure name as mentioned.(>30 Chars)
But while executing I am getting following error.

SQL> exec p_procedure_for_cals_annual_sal_oracle_proprierty.lib
BEGIN p_procedure_for_cals_annual_sal_oracle_proprierty; END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00114: identifier 'p_procedure_for_cals_annual_sal_' too long.

Please give me suggestion to execute this procedure.

Thank you.

Edited by: user636482 on Mar 22, 2009 9:57 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2009

Added on Mar 23 2009

8 comments

13,161 views