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

appdev@NICK920.US.ORACLE.COM> create table t
2 (a int,
3 b varchar2(10))
4 /

Table created.

appdev@NICK920.US.ORACLE.COM> insert into t
2 values(1, 'Hello')
3 /

1 row created.

appdev@NICK920.US.ORACLE.COM> insert into t
2 values(2, 'There')
3 /

1 row created.

appdev@NICK920.US.ORACLE.COM> commit;

Commit complete.

appdev@NICK920.US.ORACLE.COM> 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


appdev@NICK920.US.ORACLE.COM> @ 'E:\oracle\ora92\xdk\admin\xmlgen.sql'

Package created.

No errors.

Package body created.

No errors.

Grant succeeded.

appdev@NICK920.US.ORACLE.COM> select xmlgen.getXML('Select * from t')
2 from dual
3 /

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

<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<A>1</A>
<B>Hello</B>
</ROW>
<ROW num="2">
<A>2</A>
<B>There</B>
</ROW>
</ROWSET>



[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.