Re: Inserting a LONG through SQL
Date: Tue, 18 Oct 1994 21:33:21 GMT
Message-ID: <James.Lawrence.5.00108ECF_at_epamail.epa.gov>
In article <89B5229.038900153D.uuout_at_compudata.com> barry.roomberg_at_compudata.com (BARRY ROOMBERG) writes:
>From: barry.roomberg_at_compudata.com (BARRY ROOMBERG)
>Subject: Re: Inserting a LONG through SQL
>Date: Fri, 07 Oct 94 09:13:00 -0400
>-> >ORA-01704: string literal too long
>-> >
>-> >When I insert a field with more than 2000 characters. I am familiar
>-> with >the set long statement but this doesn't seem to help. Do I
>-> have to write >PRO*C to do this? This is particularly important for
>-> a Powerbuilder app >with embedded SQL. Thanks...
>-> >
>-> >Scott Prugh
>->
>-> You must use Pro*C.
>When I'm feeling lazy (which is most of the time), I'll whip
>up a SQL-LOADER driver file to load the longs.
I think you need to look at blob stuff in PB Received on Tue Oct 18 1994 - 22:33:21 CET