Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> pro*c array's returned data length (dynamic sql 4)
Hi,
I made a little pro*c app that selects rows in a host array and prints them
in a delimited format. There are varchar2 columns that have variable lengths.
A column like 'DESCRIPTION' can be anything between 0 and 2000 chars long.
l
How can I determine the actual length of the data in the DESCRIPTION column
in the array ?
in selda->L[i] I only have the maxlength of the columns.
BTW: I use dynamic sql method 4 to get the rows since I do not know anything about the tables before hand. Also I want the rows to be returned in characters, not in the internal formats.
thanks,
--
Ronald.
---
http://home.wxs.nl/~ronr/RonR.html
PGP Public Key: http://home.wxs.nl/~ronr/public_pgp_key.txt
The best way to accellerate a computer 'running' windows is by gravitation
Received on Fri Dec 10 1999 - 15:18:54 CST
![]() |
![]() |