At 05:42 PM 5/8/00 -0500, you wrote:
>In <[EMAIL PROTECTED]>, Jennifer
>([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
> > At 01:53 PM 5/8/00 -0500, you wrote:
> > >I have a <textarea> tag that I'd like to insert/update the value of into
> > >an Oracle LONG column. For simple and short values, the following works
> > >fine:
> > >update theTable set theCol = '#form.textareaname#' where <where clause>
> > >
> > >However, if I get too much text in that string literal, I get an "ORA-
> > >01704: string literal too long" error.
> > >
> > >An Oracle LONG data type can hold up to 2gb of text in it, so that's not
> > >the prob.
> > >
> > >Any ideas?
> >
> >
> > There is a 4k literal text string limit in SQL insert and update
> > statements. That is where you are being truncated. Here's the code form
> our
> > example. You will probably be able to follow the variables, but if you
> have
> > a question, email me. I'm short on time today, so I am not paying much
> > attention to the list. You may have to reply to my address in a seperate
> > email message than you reply to the list because of my filter.
> >
> > <cfstoredproc procedure="update_EditorialBody"
> > datasource="#application.EditorialDsn#"
> > username="#application.DataUserName#"
> > password="#application.DataUserPassword#" debug="Yes">
> > <cfprocparam type="in"
> > value="#EditorialID#" cfsqltype="CF_SQL_INTEGER">
> > <cfprocparam type="in"
> > value="#EditorialBody#" cfsqltype="CF_SQL_LONGVARCHAR">
> > </cfstoredproc>
> >
> > the stored procedure:
> > update_EditorialBody(p_ID IN NUMBER, b1 IN VARCHAR2)
> >
> > BEGIN
> > update tblEditorials
> > set EditorialBody = b1 where tblEditorials.EditorialID = p_ID;
> > END;
>
>Actually, there's also a <cfqueryparam> which does the same thing as
><cfprocparam>, yet one doesn't need to write a PL/SQL procedure.
In 4.5. It isn't listed in the CFML 4.0 Language Reference or in my 4.0.1
studio cfml language reference. But I'm glad to know about it, since that
might fix a problem we have.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
