Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: pro*c array's returned data length (dynamic sql 4)
In article <01HW.B4772CCE000724C91089CB3C_at_news.planet.nl>,
ronr_at_my-deja.com wrote:
> 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.
I found the solution: In selda->T[i] fill in 9 (varchar WITH LENGTH),
instead of 2 (varchar). Now I get an array of structs including the
length bytes...
--
Ronald
http://home.wxs.nl/~ronr/RonR.html
The best way to accellerate a computer 'running'
windows is by gravitation
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 14 1999 - 02:05:34 CST
![]() |
![]() |