DCOracle2 + Oracle9i stored procedure error
alienoid
alienoid at is.lg.ua
Tue Aug 27 15:18:31 EDT 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