Home » SQL & PL/SQL » SQL & PL/SQL » 'DBMS_XMLDOM' problem (9i)
'DBMS_XMLDOM' problem [message #400102] Sun, 26 April 2009 03:31 Go to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member

Dear,

i write a procedure usng 'DBMS_XMLDOM' package in oracle 9i
and get the following error:


PLS-00201: identifier 'DBMS_XMLDOM.DOMDOCUMENT' must be declared

Regards
Re: 'DBMS_XMLDOM' problem [message #400104 is a reply to message #400102] Sun, 26 April 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Does this procedure exist?
2/ Does the synonym exist?
3/ Do you have privilege to execute the package?

Regards
Michel
Re: 'DBMS_XMLDOM' problem [message #400110 is a reply to message #400102] Sun, 26 April 2009 04:37 Go to previous messageGo to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Dear Michel,

yes, all is exist.
i think it is the last one i don't have privilege to execute the package?

how can i test this???
Re: 'DBMS_XMLDOM' problem [message #400120 is a reply to message #400110] Sun, 26 April 2009 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query user_tab_privs

Regards
Michel
Re: 'DBMS_XMLDOM' problem [message #400128 is a reply to message #400102] Sun, 26 April 2009 06:40 Go to previous messageGo to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
hi michel

what i do exactly, i transfer schema from 10g to 9i
and this procedure working well in 10g, but when i transfer it
to 9i schema, it give my the ubove error??

i checked the user_tab_privs for the 10g schema

it take only execute on different package "DBMS_STATS"


Thanks alot


Re: 'DBMS_XMLDOM' problem [message #400131 is a reply to message #400128] Sun, 26 April 2009 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have not the privilege to execute the package.

Regards
Michel

[Updated on: Sun, 26 April 2009 10:00]

Report message to a moderator

Re: 'DBMS_XMLDOM' problem [message #400139 is a reply to message #400102] Sun, 26 April 2009 09:29 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Which schema owns DBMS_XMLDOM?
Which schema owns procedure that invokes DBMS_XMLDOM?

Post procedure which generates the error.
Previous Topic: query runs fast but record count is very slow
Next Topic: Avg of the count ??
Goto Forum:
  


Current Time: Sun Dec 04 12:49:28 CST 2016

Total time taken to generate the page: 0.10200 seconds