xmlgen

[salvareztur]

I used xmlgen for load xml document stored into database.
When I put
xmlgen.resetOptions
oracle says me
xmlgen.resetOptions must by declared

I have loaded xmlgen.sql

Can anybody help me??
Thanks-

[Tarry]

XSU is installed, Right?

[salvareztur]

I have install jvm and I have executed xmlgen.sql package, When I connected with sys user I see package xmlgen.

[Tarry]

You didn't say your server version. Well I just installed the xsu and did a simple test on 9R2. Seems fine to me...

Enter user-name: appdev@nick920
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining option
s
JServer Release 9.2.0.3.0 - Production

[email protected]> create table t
  2  (a int,
  3  b varchar2(10))
  4  /

Table created.

[email protected]> insert into t
  2  values(1, 'Hello')
  3  /

1 row created.

[email protected]> insert into t
  2  values(2, 'There')
  3  /

1 row created.

[email protected]> commit;

Commit complete.

[email protected]> select xmlgen.getXML('Select * from t')
  2  from dual
  3  /
select xmlgen.getXML('Select * from t')
       *
ERROR at line 1:
ORA-00904: "XMLGEN"."GETXML": invalid identifier


[email protected]> @ 'E:\oracle\ora92\xdk\admin\xmlgen.sql'

Package created.

No errors.

Package body created.

No errors.

Grant succeeded.

[email protected]> select xmlgen.getXML('Select * from t')
  2  from dual
  3  /

XMLGEN.GETXML('SELECT*FROMT')
--------------------------------------------------------------------------------



   
      1
      Hello
   
   
      2
      There
   

[1]You're sure you didn't get any compilation error during the xsu install?
[2]Is you pl/sql block(from where you're calling this resetOptions) all fine?
[3] What are you doing creating an xml doc from a table(to eventually display in the browser) or vice versa?
[4] XMLSPY is also a good option to try.