Solved

ORA-00972: identifier is too long

Posted on 2010-09-16
3
2,658 Views
Last Modified: 2013-12-07
hi,

when I am trying to execute stored procedure I got the following error.
Error report:
ORA-00972: identifier is too long
00972. 00000 -  "identifier is too long"
*Cause:    An identifier with more than 30 characters was specified.
*Action:   Specify at most 30 characters.

My declarations are
I_START_DATE IN  OUT VARCHAR2,
I_END_DATE IN OUT VARCHAR2,
OUT_CURSOR OUT SYS_REFCURSOR


Please let me know the problem

Its urgent!!
0
Comment
Question by:Mounikaa
  • 2
3 Comments
 

Author Comment

by:Mounikaa
ID: 33695763
hello..

please heli me!!
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 33695780
What is the name of the procedure?  It also needs to be less than 30 characters.

Can you post the rest of the code?
0
 

Author Closing Comment

by:Mounikaa
ID: 33695856
Thanks a lot!!
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Encryption Decryption in Oracle 12 119
Convert Oracle data into XML document 2 65
Consolidating oracle query results to a single line 8 60
form builder not starting 3 34
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question