Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ORA-00972: identifier is too long

Posted on 2010-09-16
3
2,675 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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 …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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.

808 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