Efren
|
| Posted: 06/18/2002, 2:02 PM |
|
Does CCS support Oracle LOBs like:
BLOB
Binary large object, up to 4GB.
CLOB
Character large object, up to 4GB.
http://java.sun.com/j2se/1.3/docs/guide/jdbc/clob.html explain how to use it but is dificult for most users the input of this values... also get this values from database still be a problem... and are important data types, because memo types can exceed the 4000 varchar2
there is a module or patch for this data types???
|
|
|
 |
George L.
|
| Posted: 06/19/2002, 7:50 AM |
|
Efren. I think your stuck with memo for the time being. BLOBS are not really good for quering anyway. CLOBS work well with memo.
|
|
|
|
Efren Lugo
|
| Posted: 06/19/2002, 7:54 AM |
|
I know i will use CLOB for memo, but dont work on CC2.0, it successfull insert on SQLPLUS and CC2.0... but when you make a query dont work
on SQLPLUS a simple select get the CLOB data but in CC2.0 this will not happen only appear the ID and the CLOB field cannot be sorted and dont display noting no matters what you insert...
if you want to edit the clob by click id link... will get the update form... but the clob text area still empty...
i think was not inserting data but, is inserted... when you make a query via SQLPLUS appear all the inserted data...
what can be the problem??? CLOBS are not equal to MEMOS?
|
|
|
|
|
