Re: [cx-oracle-users] Calling procedures with fancy arguments

[Anthony T. <ant...@gm...>]

Not currently. This is what is called a "named" type and is not
supported by cx_Oracle at the moment. I have plans to do so but they
have been rather long in coming, unfortunately. :-( The only arrays
that cx_Oracle supports today are PL/SQL arrays, not SQL named types
Of course, if anyone wanted to add support and send me a patch, I'd be
very grateful.... :-)

On 7/25/05, Walter D=F6rwald <wa...@li...> wrote:
> I'm trying to call a stored procedure that looks like this:
>=20
> create or replace procedure test_integers
> (
>     p_test integers
> )
> is
> begin
>     null;
> end;
>=20
> The type integers is defined like this:
>=20
> create or replace type integers as table of integer;
>=20
> I don't care about the value of the argument (NULL would be perfectly
> fine), but neither
>     cursor.callproc("test_integers", [None])
> nor
>     cursor.callproc("test_integers", [[]])
> work. Is there any way to call this procedure with cx_Oracle?
> (cx_Oracle 4.1 with "Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> Production")
>=20
> Bye,
>     Walter D=F6rwald
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclic=
k
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>