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
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 !