OCI & PL/SQL Tables of records (ORACLE 7.3.3.6,OpenVMS)

From: Ruslan R. Laishev <Laishev_at_SMTP.DeltaTel.RU>
Date: Sat, 12 Feb 2000 04:43:29 +0300
Message-ID: <38A4BAC1.7B1EA44A@SMTP.DeltaTel.RU>

Hi !

        I try to write an application (OCI , C) which call a procedure from package, C program use "Table of records" as parameters transfered to the PL/SQL procedure, follows some part of code for demonstration purpose:

PL/SQL part:
--

create  or replace package zz      as
        type zz_rec is record (
		field0	varchar2[16];
		field1	varchar2[16];
		);
	type zz_tbl is table of zz_rec index by binary_integer;


--


	function zz_func	(
                                in_data  in zz_tbl, in_count in integer,
                                out_data in zz_tbl, out_count out
integer
                                ) return integer;

--

end;

C+OCI stuff:

{
char in_data [32] [32], char out_data [32] [32];

...

        if ( status = oparse(&cda,":retcode := zz_func (:in_data......)" ,-1,0,VERSION_7) )
...

        if ( status =
obndrv(&cda,":in_data",-1,&in_data,sizeof(in_data),SQLT_???,-1,0,0,-1,-1) )
...
}

        The question is: what type of ORACLE data I'm need to use instead of "SQLT_???" ?         TIA.
--

Regards.

+.....................pure personal opinion..........................+
    Free & commercial software for ISP -> http://WWW.RadiusVMS.COM

	Cel:+7 (901) 971-3222, Fax:+7 (812) 115-1035

+..... Kick ass VMS solution listening "Nightingales & Bombers" .....+ Received on Fri Feb 11 2000 - 19:43:29 CST