Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: pro*c array's returned data length (dynamic sql 4)

Re: pro*c array's returned data length (dynamic sql 4)

From: Ronald J.H. Rood <ronr_at_my-deja.com>
Date: Tue, 14 Dec 1999 08:05:34 GMT
Message-ID: <834toe$jv6$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US