Re: CLOBs in Forms 6

[Quoted] [Quoted] I just created a table such as the following:

CREATE TABLE test (
testblob BLOB,
testclob CLOB);

Then created a form and used that table for the block.

Opened the form and wrote lots of formatted data into the CLOB and did a Control-C-Control-V paste of an image file (.jpg) into the BLOB.

Closed the form and reopened it. Text is there and image is there.

[Quoted] If you are having a problem something else is going on.

Daniel Morgan

"guycorbett_at_my-deja.com" wrote:

> > They most certainly are supported. And not just in 6i ... back to 6.0.
> >
> > Daniel Morgan
>
> Have you got them to work? If so could you point out where I am going
> wrong. I am using Forms 6.0.8.13 on Windows 98 client with Oracle 9I
> on Solaris server.
>
> To simplify the problem, I created a table with just 2 fields, a
> varchar2(2) and a CLOB field, I created a form using the data block
> and layout wizards. The clob field was created as a text-item of data
> type long (CLOB is not in the dropdown list) length 240. If I run this
> default form and execute the query I get Oracle 40505 unable to
> execute query, if I insert a record it is successful and I can see the
> data from SQLPLUS. If I replace the CLOB field with a LONG field and
> recompile the form it works properly but I believe the idea is to
> migrate from LONGs to CLOBs rather than the other way round.
>
> In the absence of another solution and because you can only have one
> long field per table, I am currently cobverting them all to multiple
> varchar2(2000) fields and writing code in the form to join/split them
> to allow editing.
>
> Thanks,
> Guy
Received on Fri Apr 12 2002 - 17:07:51 CEST