Curious, I am.
Is the error that you're getting:
Oracle Error Code = 1704
ORA-01704: string literal too long
I ask because I'm working with Spectra on an Oracle db and that error is
beginning to be a big bug in my hide. I'd like to know if your problems and
mine might be related.
> -----Original Message-----
> From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 12:37 PM
> To: CF-Talk
> Subject: RE: client variables, WDDX, and Oracle
>
>
> Surely you don't have to store that much info on each item?
>
> -----Original Message-----
> From: Scott Weikert [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 5:21 PM
> To: CF-Talk
> Subject: client variables, WDDX, and Oracle
>
>
> Hey gang -
>
> Got a quandary here. We're working on a order placement
> system. The plan is
> to keep a running status of the order in a client variable,
> stored in WDDX.
> Top of each page, deserialize the packet, add/adjust the
> contents of the
> resulting structure based on the previous form's content,
> reserialize into
> the client variable.
>
> We're running Oracle - and apparently Oracle has a 4k
> character limit on
> fields. So getting just a few items into this
> structure/packet (lots of info
> per item) is making us hit this upper character limit, and
> the thing bombs.
>
> Suggestions? Any way to get around that limit on Oracle? A
> couple of ideas
> we've batted around are using an application variable to
> store this stuff
> temporarily and nuking it once the order is placed, or using
> the file system
> to read/write to a file instead of a client variable.
>
> --Scott
>
>
> **********************************************************************
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received
> it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **********************************************************************
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
