Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating the whole xml file in XMLType column

491404Apr 25 2006 — edited Apr 26 2006

Hi ,
I am facing the problem in updating the XMLTYPE column.
I need to update the whole xml file

This is my table

SQL> desc EMPJAL_TABLE;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPLOYEEID NOT NULL VARCHAR2(140)
EMPCOM VARCHAR2(100)
EMPJAL SYS.XMLTYPE(XMLSchema "www.EMPSIM.com" Element "EMPJAL") STORAGE
Object-relational TYPE "EMPJAL_T"

I am able to form the CLOB object and trying to use this sql command

UPDATE EMPJAL_TABLE SET EMPJAL = XMLType( ? ) ) WHERE EMPLOYEEID ='emp1234';

Here I want to update the whole xmlfile in XMLTYPE column.

Error is - ORA-00933: SQL command not properly ended

Please advise

Thanks
Govinds

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2006

Added on Apr 25 2006

#performance-availability, #xml-db

3 comments

425 views