Hi...,
When I call a Oracle package I get this error message.
java.sql.SQLException: ORA-01948: identifier's name length (39) exceeds maximum (30)
ORA-06512: at "SYS.DBMS_PICKLER", line 18
ORA-06512: at "SYS.DBMS_PICKLER", line 58
ORA-06512: at line 1
There is not way we can change the package name. How do we fix it on the java side?
Regards,
Praveen
The statement 'ORA-01948' is coming from the database and not your java program. Therefore you cant fix it on the java side. There is some stored procedure, stored function, or other such code on the database that is too long. Use a database utility tool such as 'Toad' to examine the database and see if you can find what SYS.DBMS_PICKLER means.
Here is a definition of ORA-01948 I found on the internet:
ORA-01948: identifier's name length (string) exceeds maximum (string)
Cause: A name has been specified that is too long. For example, dbms_session.is_role_enabled() specifies a role name that is too long.
Action: Change the application or command to use a correct identifier.
