PL/SQL, passing records across OCI 7.1

From: <C.Reece_at_pindar.com>
Date: Mon, 13 Jul 1998 13:01:17 GMT
Message-ID: <6od0et$2do$1@nnrp1.dejanews.com>

I'm trying to find a way to pass a record (or ref cursor) from an OCI 7.1 client (Mac) to a stored proc on an Oracle 8 DB. The DB will quite happily return the description details, but the external types mentioned are not defined in the OCI 7.1 headers -- but they are mentioned in the 7.3 headers, record is 250, ref cursor is 102.

The description shows the members of the record structure, but I don't know how to bind variables to the described components. For instance, I have a stored procedure returning a record of type emp%ROWTYPE. On an OCI 7.1 client odessp returns the following info:

Parameter O'load Pos Level Len Dtype Defsup Mode Dtsize Prec Scale Radix

---

• EMPREC 0 1 0 6 250 0 1 0 0 0 0 EMPNO 0 1 1 5 2 0 1 22 4 0 10 ENAME 0 2 1 5 1 0 1 10 0 0 0 JOB 0 3 1 3 1 0 1 9 0 0 0 MGR 0 4 1 3 2 0 1 22 4 0 10 HIREDATE 0 5 1 8 12 0 1 0 0 0 0 SAL 0 6 1 3 2 0 1 22 7 2 10 COMM 0 7 1 4 2 0 1 22 7 2 10 DEPTNO 0 8 1 6 2 0 1 22 2 0 10

Is there any way to bind variables to the components at ``level 1'', or to bind a whole struct to the record at ``level 0''?

I may be missing something obvious. Maybe OCI 7.1 just can't cope with this sort of thing? Is there a later version of the OCI available for the Mac?

Any help gratefully received.

Cheers,

Chris.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 08:01:17 CDT