DCOracle2 + Oracle9i stored procedure error
mfranklin1 at gatwick.westerngeco.slb.com
Tue Aug 27 22:26:05 CEST 2002
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
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 ?
> 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
> return 1;
> 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.
More information about the Python-list