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 -> pro*c array's returned data length (dynamic sql 4)

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

From: RonR <ronr_at_my-deja.com>
Date: Fri, 10 Dec 1999 22:18:54 +0100
Message-ID: <01HW.B4772CCE000724C91089CB3C@news.planet.nl>


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

Original text of this message

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