|
Replies:
4
-
Pages:
1
-
Last Post:
Oct 8, 2009 8:09 PM
by: stevenfeuerstein
|
|
|
Posts:
1
Registered:
1/16/09
|
|
|
|
A New Test Raises: ORA-06502: PL/SQL: numeric or value error
Posted:
Jan 16, 2009 6:30 AM
|
|
|
Error code: 10000002
Error name: UNANTICIPATED-ERROR
Error details:
Unexpected failure when initializing test definition from program definition.
An unanticipated error has occurred. Please review the information below and see if it will help you resolve the problem.
ORACLE_ERROR = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Comments:
Be informed that functions and procedures inside a package have to be shorter than Oracle’s 30 character limit. The procedure with the name "generate_termination_invoices" has twenty nine characters and raises the 6502 error when a new test case is attempted. When the routine's name is shortened then, the 6502 error goes away.
Workaround:
One workaround is to build a second package that has the subroutine with a shortened name. The second routine simply calls the original routine.
|
|
|
Posts:
204
Registered:
5/18/06
|
|
|
|
Re: A New Test Raises: ORA-06502: PL/SQL: numeric or value error
Posted:
Jan 20, 2009 4:49 AM
in response to: Bottom_End
|
|
|
This should not be happening and I am having a hard time reproducing it. Please contact support.quest.com to log a bug.
|
|
|
Posts:
1
Registered:
2/10/09
|
|
|
|
Re: A New Test Raises: ORA-06502: PL/SQL: numeric or value error
Posted:
Feb 10, 2009 3:12 PM
in response to: stevenfeuerstein
|
|
|
I don't know whether this problem/error has been reported as a bug or has been fixed or not.
Just want to confirm that I also experienced the same problem as the previous person (ie. User: Bottom_End) when trying to create a new test (ie. Loading an existing oracle package). The existing package was compiled fine in PL/SQL Developer.
By the way, how do I know if this problem has been reported as bug or has been fixed?
|
|
|
Posts:
2
Registered:
10/8/09
|
|
|
|
Re: A New Test Raises: ORA-06502: PL/SQL: numeric or value error
Posted:
Oct 8, 2009 3:14 PM
in response to: RSumarno
|
|
|
I'm having the same problem
|
|
|
Posts:
204
Registered:
5/18/06
|
|
|
|
Re: A New Test Raises: ORA-06502: PL/SQL: numeric or value error
Posted:
Oct 8, 2009 8:09 PM
in response to: patrocinio.rica...
|
|
|
Patrocinio,
Sorry, but same message as in other post. I just created and ran a test for a program named generate_termination_invoices, so I need to get more of your specifics. When you get the error, create a support bundle and send it to me:
steven.feuerstein@quest.com
Thanks, SF
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
