Extremely helpful
Sajid Anwar, August 14, 2002 - 3:32 am UTC
Thanks a million Sean and Tom. It was really very helpfull. I would definitely try that and would let you know. Thanks once again.
Best Regards,
Sajid Anwar
London
XSQL exception
Saradha Bavanandam, November 13, 2002 - 2:13 pm UTC
Tom,
Can you please help me in resolving the following XSQL error.
oracle.xml.sql.OracleXMLSQLException: Internal Error: Unable to resolve name
After I drop and re-create an object types, which has dependents, XSQL Servlet raises exception for a query that is working fine in the Oracle Server itself (ie, in SQL*Plus) as in the following test case:
CREATE OR REPLACE TYPE o_object_inner
AS OBJECT ( char1 char(1) )
/
CREATE OR REPLACE TYPE n_nested_table
AS TABLE OF o_object_inner
/
CREATE OR REPLACE TYPE o_object_outer
AS OBJECT ( nNestedTab n_nested_table )
/
For above, the following query encounters no problems on Oracle Server or in XSQL servlet:
SELECT o_object_outer(NULL) AS "theOuterObj" FROM dual
But if I want to make a change to o_object_inner object type then I drop this object type using FORCE and re-create this with the modification.
DROP TYPE o_object_inner FORCE
/
CREATE OR REPLACE TYPE o_object_inner
AS OBJECT (char1 char(1) )
/
SELECT o_object_outer(NULL) AS "theOuterObj" FROM dual
The above query now encounters no problems in SQL*Plus but generates exception in XSQL servlet as follows:
oracle.xml.sql.OracleXMLSQLException: Internal Error: Unable to resolve name
Any insight or help would be greatly appreciated!
But If I drop all of the dependents and recreate them in the
order then It works fine.
Other info:
Oracle Server 8.1.7.4 on HP-UX
XDK 9.2.0.1 (Production) for Java on NT
JDBC/OCI8 drivers for NT (latest for 8.1.7)
Thanks
Pushparaj
November 13, 2002 - 2:21 pm UTC
can you try restarting the servlet engine, looks like it is caching some stuff and when you drop and recreate -- the cached data is "not right" anymore.
XSQL exception
Saradha Bavanandam, November 13, 2002 - 3:44 pm UTC
Tom,
Thank you for your quick response.
Actually I get this error only if I stop and restart the engine.
Let me give you the sequence.
1) Start the Servlet engine (tomcat)
2) Run the query from XSQL
SELECT o_object_outer(NULL) as "theOuterObj" FROM dual
3) No error raised.
4) Drop and re-create n_nested_table type.
5) Run the same query from XSQL
SELECT o_object_outer(NULL) as "theOuterObj" FROM dual
6) No error raised and it works fine.
7) Stop and restart the servlet engine.
8) Run the same query from XSQL
SELECT o_object_outer(NULL) as "theOuterObj" FROM dual
9) Now the error is raised as
oracle.xml.sql.OracleXMLSQLException: Internal Error: Unable to resolve name
Thanks again.
November 13, 2002 - 6:03 pm UTC
i'll have to refer you to support -- never seen this myself.