OraFAQ Forum: JDeveloper, Java & XML » ora-06550 identifier dbms

Home » Developer & Programmer » JDeveloper, Java & XML » ora-06550 identifier dbms_xmlparser.Parser must be declared.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #300357]

Fri, 15 February 2008 03:22

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.

Report message to a moderator

Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #300366 is a reply to message #300357]

Fri, 15 February 2008 04:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Possible reasons:
- synonym does not exist
- package does not exist
- you don't have access to the package

Regards
Michel

Report message to a moderator

Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #301515 is a reply to message #300366]

Wed, 20 February 2008 23:14

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.

Report message to a moderator

Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #301532 is a reply to message #301515]

Thu, 21 February 2008 00:05

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.

Report message to a moderator

Re: ora-06550 identifier dbms_xmlparser.Parser must be declared. [message #302887 is a reply to message #300357]

Wed, 27 February 2008 04:32

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 00:50:00 CST 2024