Skip to Main Content

DevOps, CI/CD and Automation

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!

inserting clobs

364156Nov 14 2002
I have written an xsl page which is very long (about 6k) and I think to store it in a table in a clob field so that I could retreive it later to apply to my xml page by using dbms_xmlquery.setxslt(queryctx,xslt_clob);

I am trying to insert xsl page directly into a table like this:

create table temp_table(xslt_clob clob);

insert into temp_table(xslt_clob) values (
'<xsl:stylesheet version="1.0" xmlns:xsl=" " target="_new">http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/">
<MainTag>
...
</MainTag> '
);


When I do that I get an error:
ORA-01704: string literal too long

Are there any other ways to insert clob into and retreive it from a table?

Thanx.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2002
Added on Nov 14 2002
4 comments
333 views