Re: cx_Oracle, callfunc and varray

2015-01-09 Thread Ian Kelly
On Fri, Jan 9, 2015 at 12:24 PM, Dom wrote: > Hi > > I'm trying to return a simple array of numbers from a package using cx_oracle > (5.1.2). I believe this is possible. I've not been able to find anything that > suggest it isn't I'm afraid I don't have an answer for you, but you would probably

Re: cx_Oracle, callfunc and varray

2015-01-09 Thread John Gordon
In Dom writes: > create or replace PACKAGE SIMPLEPACKAGE > AS > FUNCTION DoSomethingSimple( > cust_id INTEGER) > RETURN numarray; > FUNCTION DoSomethingSimpler( > cust_id INTEGER) > RETURN INTEGER; > END SIMPLEPACKAGE; > / > Any ideas what I'm doing wrong? Is RETURN IN

cx_Oracle, callfunc and varray

2015-01-09 Thread Dom
Hi I'm trying to return a simple array of numbers from a package using cx_oracle (5.1.2). I believe this is possible. I've not been able to find anything that suggest it isn't create or replace TYPE NUMARRAY -- Simple VArray of numbers is VARRAY(3) OF NUMBER; / create or replace PACKAGE SIMPLE