Home » Developer & Programmer » JDeveloper, Java & XML » ora-06550 identifier dbms_xmlparser.Parser must be declared.
icon7.gif  ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #300357] Fri, 15 February 2008 03:22 Go to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member

Hi,

I am trying to execute the following PL/SQL block:

DECLARE
l_bfile BFILE;
l_clob CLOB;
l_parser dbms_xmlparser.Parser;
l_doc dbms_xmldom.DOMDocument;
l_nl dbms_xmldom.DOMNodeList;
l_n dbms_xmldom.DOMNode;
l_temp VARCHAR2(1000);

TYPE tab_type IS TABLE OF emp%ROWTYPE;
t_tab tab_type := tab_type();
BEGIN
.....
END;

But the error is shown as:
ora-06550 identifier dbms_xmlparser.Parser must be declared.
ora-06550 identifier dbms_xmldom.DOMDocument must be declared.
ora-06550 identifier dbms_xmldom.DOMNodeList must be declared.
ora-06550 identifier dbms_xmldom.DOMNode must be declared.
.....
.....

What could be the cause for the same?


Thanks,
Priya.


Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #300366 is a reply to message #300357] Fri, 15 February 2008 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Possible reasons:
- synonym does not exist
- package does not exist
- you don't have access to the package

Regards
Michel
Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #301515 is a reply to message #300366] Wed, 20 February 2008 23:14 Go to previous messageGo to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member



Hi,

Thanks for providing the possible causes.

But I would like to know which one is causing the ora error 06550.

Thanks,
Priya.


Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #301532 is a reply to message #301515] Thu, 21 February 2008 00:05 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You will have to find out yourself; we cannot tell you without access to your database, as it could be either of those.
Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #302887 is a reply to message #300357] Wed, 27 February 2008 04:32 Go to previous message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,

Can you tell the steps to verify cases against the mentioned causes.

Thanks,
Priya.

[Updated on: Wed, 27 February 2008 04:32]

Report message to a moderator

Previous Topic: oracle.AQ
Next Topic: How I can display Picture in database in XML output.
Goto Forum:
  


Current Time: Thu Mar 28 12:11:44 CDT 2024