DCOracle2 + Oracle9i stored procedure error

alienoid alienoid at is.lg.ua
Tue Aug 27 21:18:31 CEST 2002


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





More information about the Python-list mailing list