Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Long raw with DynamicSQL?
Greetings.
Problem:
I have a table that contains a LONG RAW colum. Each element of the column
has variable length.
Question:
How can I obtain the length of the element in a select/fetch using dynamic
SQL? DESCRIBE SELECT LIST tells me about the datatype but not about it's
length. But as I don't known it's length, I cannot allocate a buffer large
enough to FETCH the data item, so my only current solution is to guess the
length which isn't very nice at all.
Any help would be appreciated.
-- Markus Schoepflin www: http://www.ginit.de GINIT Gesellschaft fuer integrierte email: schoepflin_at_ginit.de Informationssysteme mbH phone: +49 721 9 66 81 67 Vincenz-Priessnitz-Str. 1 fax: +49 721 9 66 81 11 D-76131 Karlsruhe, GermanyReceived on Tue Apr 29 1997 - 00:00:00 CDT