Re: LONG data type questions
Date: 1995/04/10
Message-ID: <D6toBo.F0q_at_zcias2.ziff.com>#1/1
In article <3m1d6n$pdp$1_at_mhadf.production.compuserve.com>, Jay D. Sullivan <70614.42_at_CompuServe.COM> says:
>
>I'm trying to use the LONG data type for the first time and I'm
>having a few problems. It seems to only be storing a maximum of
>256 characters. When I issue an INSERT statement with a 300
>character string, the insert seems to work but when I select the
>data back to make sure that it worked, I only get 256 characters
>back.
>
Can't insert more then 256 char via SQL-Plus. All literals must be 256 chars or less, which is where you are storing your data before sending it so SQL.
Use SQL-Loader if you can. If not, PRO-C or OCI.
>Also, once I get this fixed, is there any way to only select a
>substring of the LONG data type without using the Oracle Call
>Interface?
>
No. Received on Mon Apr 10 1995 - 00:00:00 CEST