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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Retrieving PL/SQL associative arrays with OCCI...

RE: Retrieving PL/SQL associative arrays with OCCI...

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 25 Jan 2007 15:01:55 -0700
Message-ID: <7209E76DACFED9469D4F5169F9880C7A6753E1@mail01bldr.arraybp.com>


Not to be picky ...

I don't see NumArray defined in your package. I see IntArray.

--

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Geoffrey E. Quelch Sent: Thursday, January 25, 2007 2:55 PM To: Oracle List
Subject: Retrieving PL/SQL associative arrays with OCCI...

All,
I'm wondering if anyone can give me a pointer or two to help me resolve a
problem.

I have a package body defining an associative array:

CREATE OR REPLACE PACKAGE PK_WS_Data AS

and now I need to be able to access data of this type returned by a procedure
in this package as an OUT variable. How does one do this in OCCI?

My attempt is as follows:

std::vector<float> values;
...
stmnt->registerOutParam( 7, oracle::occi::OCCIVECTOR, 0, "PK_WS_Data.NumArray");
...
oracle::occi::getVector(rs, (unsigned int) 7, values);

(which all refer to the same data item) but I get an error: OCI-22303: type "PK_WS_Data"."NumArray" not found. Whatever I place in the last argument of the register call gives a similar
runtime error.

I have found a metalink item: 308592.1 that seems to refer to something similar, but they are using an object type, and not using a package.

Does anyone have an example closer to what I'm doing? The OCCI documentation
doesn't have anything similar that I've found.

Do I need to define this type external to the package and if so what code
change would I need?

I have been able to do this in PHP easily which is funny, PHP is usually

harder than OCCI... :-)

Many thanks in advance,
GEQ
--

Geoff Quelch
Email: gequelch_at_frii.net

--

http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 25 2007 - 16:01:55 CST

Original text of this message

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