ORA-06502 error

[ranjitvictor]

This is the situation:

Database - Oracle 7.3.2
Package - "routine_orders"
procedure- "process_routine_orders" (inside the package)
I have also created the following synonyms for the package "routine_orders" - 1) "TEST" (4 chars)
- 2) "ROUTINE_TESTING" (15 chars)

Now in PB 7.0 I make the following declaration

DECLARE routine_orders procedure FOR
TEST.process_routine_orders(); // Works perfectly

DECLARE routine_orders procedure FOR
ROUTINE_TESTING.process_routine_orders(); // Doesn't work

I have noticed that when the combined length of the synonym and the procedure is less than or equal to 32, it works fine, on the other hand, if the combined length exceeds 32 characters as in the case of "ROUTINE_TESTING.process_routine_orders", the following error is generated,

ORA-06502 PL/SQL: numeric or value error.

Any solutions?

 

[deltas]

It is a constrain in Oracle ,The name of the object should not cross 32 chars.

cool buddy...