inserting clobs
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.