OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » : ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.DBMS

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » : ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared ORA-0655

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

: ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared ORA-0655 [message #648683]

Mon, 29 February 2016 13:02

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

I use an Oracle Express Edition 10.2.0.1.0 on Linux server.

It seems error SYS.DBMS_XQUERYINT required java into Oracle ? could you confirm me ?

Currently Java is installed on this Linux, but outside Database

How could i realize it ?

Regards
Phil

Report message to a moderator

Re: : ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared ORA-0655 [message #648684 is a reply to message #648683]

Mon, 29 February 2016 13:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Have a look at this OTN forum discussion, especially mdrake-Oracle

XQuery is not available in XE due to a dependancy on Java in the database

which means that there's nothing much you can do about it. Though, someone else might know better. Also, research My Oracle Support, maybe you'll find some good news.

Report message to a moderator

Previous Topic:	LOV with Static and dynamic values
Next Topic:	Recompil All Page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 06:06:44 CST 2025