Sunday, July 21, 2013

SQLJUTL Package Error - Database Adapter Creation - Oracle XE

When we try to create a database adapter to execute procedure or function exists in XE database, following error message will be displayed during adapter configuration.

java.sql.SQLSyntaxErrorException: ORA-00904: "SYS"."SQLJUTL"."HAS_DEFAULT": invalid identifier

Given error happens due to missing of required SQLJUTL package from XE.

To resolve this error, you have to compile SQLJUTL package script in XE database. The SQLJUTL package script can be found in Enterprise Database installation SQLJ directory.

For Ex: /home/oracle/healthcare/product/11.2.0/dbhome_1/oc4j/sqlj/lib

No comments:

Post a Comment

Provide your thoughts !