Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2851
  • Last Modified:

ORA-00972: identifier is too long

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
Mounikaa
Asked:
Mounikaa
  • 2
1 Solution
 
MounikaaAuthor Commented:
hello..

please heli me!!
0
 
slightwv (䄆 Netminder) Commented:
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
 
MounikaaAuthor Commented:
Thanks a lot!!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now