Re: CLOBs in Forms 6

From: guycorbett_at_my-deja.com <(guycorbett_at_my-deja.com)>
Date: 12 Apr 2002 01:09:23 -0700
Message-ID: <ad029fc8.0204120009.18bd6650_at_posting.google.com>


> They most certainly are supported. And not just in 6i ... back to 6.0.
>
> Daniel Morgan

[Quoted] 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 - 10:09:23 CEST

Original text of this message