Re: OCI calling PL/SQL help!

In article <43msrq$96n_at_inet-nntp-gw-1.us.oracle.com>, bconnor_at_uk.oracle.com wrote:

>In article <rickmich-1809950924480001_at_rickmich.dialup.access.net>,
 rickmich_at_panix.com (Rick Michaud) writes:
>|>
>|> I am trying to set up a middleware layer that allows users to call
>|> packaged procedures in an ad-hoc manner. The layer is based on OCI
>|> and basically uses OCI calls to determine the parameters to the
>|> procedure. I have gotten the code to work for scalar values,
>|> but I have having troubles using arrays.
>|>
>|> I am simply trying to bind an element of a 3 dim array via
>|> obndra(). I get either seg faults, or array size errors during the
>|> oexn() call.
>
>Works for me. This can obviously only be used to bind to parameters
>that are PL/SQL tables (I say obviously, but the OCI documentation is
>not in fact that obvious). Can you include some (concise :-}) code fragments?
>
>Brett
>
>---------------------------------------------------------------------------
>This is not an official Oracle statement.

Thanks for the response.

I actually solved the problem by some longwinded tinkering. It appears that the cardinality of some of the parameters must be maintained in exact proportions. For example, if using a 3 dim host array (progv), you must use 2 dim for the indicator (indp), return code (arcode), and length (alen) parameters.

Additionally, the "maxsiz" parameter description is incorrect, I found that the cdemo4.c example in the appendix uses this parameter correctly. It is actually the maximum number of elements in the array.

I also found out that the describe call returns 2 values for each pl/sql table parameter.

Why doesn't the manual explain more -- are there other OCI manuals or books I can get my hands on?

-- 
_____________________________________________________
Rick Michaud
Citibank, N.A.
Senior Systems Officer
1 Court Square, 39th Floor
Long Island City, NY  11120
_____________________________________________________