Re: [Orclib-users] Question about calling procedures in packages with custom types

[vincent r. <vin...@gm...>]

Hello,

PL/SQL records and tables of records cannot be used outside PL/SQL. In
order to use collections in PL/SQL,SQL and host programs, you must use SQL
collections (varrays or nested tables).
Thus you need to create an object type and a nested table of objects.
Change your record definition to an object type definition.
You can have a look at the ocilib demo source files for definition and
usage :)

Regards,

Vincent
Le 11 nov. 2013 14:13, "Florian Grißmer" <spi...@gm...> a écrit :

> Hi
>
> I have a question about an OCI_Collection Argument of a procedure. Suppose
> I have a procedure defined in a package like this:
>
> CREATE OR REPLACE
> PACKAGE TEST_PACK AS
>
>   TYPE test_rcd IS RECORD ( testnum Number(4,0)
>                           , test_varchar Varchar(14) );
>
>   TYPE list_of_rcds IS TABLE OF test_rcd;
>
>   Procedure test_prc1 ( rcd IN Out list_of_rcds ) ;
>
>
> END TEST_PACK;
>
> Ho do I call this procedure with a binded argument? To build the
> "rcd"-OCI_Collection Variable i have to have an OCI_TypeInf, which I cant
> get, because the type is inside a package. OCI_TypeInfoGet() uses
> "Describe" and this can't access types inside packages.
>
> Thx in advance.
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models.
> Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and
> register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> _______________________________________________
> Orclib-users mailing list
> Orc...@li...
> https://lists.sourceforge.net/lists/listinfo/orclib-users
>
>