DCOracle2 + Oracle9i stored procedure error

[Martin Franklin]

On Tuesday 27 Aug 2002 7:18 pm, alienoid wrote:
> Hello python-list users,
>
> I need your help.
>
> RH7.2 + DCOracle2 + Oracle9i (Oracle and python app are on the same
> machine)
>

Only a question i'm afraid,  did you compile DCOracle2 yourself?  If not try 
doing that and you may get a bit further, AFAIK DCOracle has only been tested 
with Oracle 8i


> When I try to call stored procedure I get:
>
> Traceback (most recent call last):
>   File "db.py", line 4, in ?
>     c.procedure.test_it('n')
>   File "/usr/lib/python2.2/site-packages/DCOracle2/DCOracle2.py", line
> 1344, in __call__ cursor.execute(sql,__plist=args)
>   File "/usr/lib/python2.2/site-packages/DCOracle2/DCOracle2.py", line 903,
> in execute result = self._cursor.execute()
> dco2.DatabaseError: (1460, 'ORA-01460: unimplemented or unreasonable
> conversion requested')
>
>
> test_it() code:
>
> create or replace procedure test_it(p in varchar2) return
> binary_integer is
> begin
>      return 1;
> end;
>
> I tried with different procedures and functions - result is the same.
>
> These procedures work when I call them within PL/SQL code.
>
> Yout help, suggestions are very, very, very appreciated.