Re: Long to varchar2?

3bohlman_at_rzdspc5.informatik.uni-hamburg.de (Holger Bohlmann) wrote:

>Hello,
 

>is there anybody out there, who knows, how I can convert a
>LONG-Value in a VARCHAR2-Value (in Oracle?). Is it possible
>to do that?
 

>Holger Bohlmann

It is possible to convert them using a rather crude trick: Create a form in Forms 3.x and query-up the data into the form field (lets say :blk.dat), then using PL/SQL inside the form, you can reference :blk.dat and carryout functions on it (e.g., SUBSTR or whatever), you can now write routines to insert the database...

Don't forget to define you :blk.dat field as a LONG with a length of 65000 (approx). The drawback is that it can only take about 64K from the beginning of the field... Received on Fri Jun 14 1996 - 00:00:00 CEST