It didn't seem like anyone was coming through with any code for you...
>type something like this in SQL command line: CREATE PROCEDURE
>update_Body(p_ID IN NUMBER, b1 IN VARCHAR2)
>BEGIN
>UPDATE TABLENAME
>SET BODY = b1 WHERE TABLENAME.ID = p_ID;
>END;
>In cfm page:
><cfstoredproc procedure="update_Body" datasource="datasourcename" debug="Yes">
><cfprocparam type="in" value="#ID#" cfsqltype="CF_SQL_INTEGER">
><cfprocparam type="in" value="#Body#" cfsqltype="CF_SQL_LONGVARCHAR">
></cfstoredproc>
>
>This sets up a variable that can contain mucho text and dumps the text in
>the variable. Then it puts the variable in the SQL statement. Then it's not
>a 4k LITERAL text string.
>
>
>
>At 04:50 PM 7/5/00 -0700, you wrote:
> >Anyone know of any new workarounds for the 4000 character limit on
> >updates/inserts to an Oracle database, or a fix for the problem? This is
> >the one that returns an error of "string literal too long". I am on CF4.5,
> >Oracle8.0.5, NT4.0, native drivers. It works using a stored procedure, but
> >my code for the stored procedure below, which is as simple as I think I can
> >get it, is taking too long. If it fails on the insert and then does the
> >update, the normal scenario, I'm losing about 60-80ms, compared to the 10ms
> >it takes to select the same data out of the table through the native
> >drivers.
> >
> >Thanks for any insights . . . .
> >Dan
> >
> >** Oracle Stored Procedure **
> >procedure update_state(p_cfid IN varchar2, p_state IN long)
> >as
> >begin
> > insert into app_state
> > (cfid, state, lastwritten)
> > values
> > (p_cfid, p_state, sysdate);
> >exception
> > when dup_val_on_index then
> > update app_state
> > set state = p_state,
> > lastwritten = sysdate
> > where cfid = p_cfid;
> >end;
> >
> >-------------------------------------------------------------------------
> -----
> >Archives: http://www.mail-archive.com/[email protected]/
> >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.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
