Home » SQL & PL/SQL » SQL & PL/SQL » Write the XML into CLOB using PL/SQL Procedure (merged 2 threads)
Write the XML into CLOB using PL/SQL Procedure (merged 2 threads) [message #284924] Sun, 02 December 2007 22:44 Go to next message
ngopimca
Messages: 3
Registered: December 2007
Junior Member
Guys,

Give me the sample code for

Write the XML into CLOB using PL/SQL Procedure
Write the XML into CLOB using PL/SQL Procedure [message #284925 is a reply to message #284924] Sun, 02 December 2007 22:45 Go to previous messageGo to next message
ngopimca
Messages: 3
Registered: December 2007
Junior Member
Guys,

Give me the sample code for

Write the XML into CLOB using PL/SQL Procedure
Re: Write the XML into CLOB using PL/SQL Procedure [message #284932 is a reply to message #284925] Sun, 02 December 2007 23:08 Go to previous messageGo to next message
ngopimca
Messages: 3
Registered: December 2007
Junior Member
Here i've created one Procedure..But when i call to that procedure
i'm getting error like this

DECLARE
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.XMLDOM" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 20


What should i do?

Please advice me..
  • Attachment: new.sql
    (Size: 2.99KB, Downloaded 502 times)
Re: Write the XML into CLOB using PL/SQL Procedure [message #284980 is a reply to message #284932] Mon, 03 December 2007 01:13 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Connect as sys, compile invalid objects (how did they become invalid in the first place?). Then connect as a regular user and try again. Do not fiddle with the SYS user too much.

MHE
Previous Topic: get name of all computer on network
Next Topic: how can i remove the garbage table name from tab
Goto Forum:
  


Current Time: Sat Feb 15 10:17:55 CST 2025