DCOracle2 + Oracle9i stored procedure error

[Anthony Tuininga]

Ok, this looks like an Oracle issue, not a Python one. First, if you
want to return something in Oracle, you must define it as a function,
not a procedure. Second, there are some issues with Oracle 9i and the
OCI which I have discovered in the development of cx_Oracle (another
Python database access module for Oracle) and this might be one of them.
I have tried this with cx_Oracle and it works so if you want to give
that a try instead, let me know.

On Tue, 2002-08-27 at 13:18, alienoid wrote:
> Hello python-list users,
> 
> I need your help.
> 
> RH7.2 + DCOracle2 + Oracle9i (Oracle and python app are on the same
> machine)
> 
> 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.
> 
> 
> -- 
> Best regards,
>  alienoid                          mailto:alienoid at is.lg.ua
> 
> 
> -- 
> http://mail.python.org/mailman/listinfo/python-list
-- 
Anthony Tuininga
anthony at computronix.com
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com