[Zope] Urgent!!! Help needed with DCOracle2 + Stored procedure + Oracle9i

[alienoid]

Hello zope users,

I need your help.

RH7.2 + Zope2.5.1 + DCOracle2 + Oracle9i

When I try to test stored procedure from within ZMI I get:

'ORA-01460: unimplemented or unreasonable conversion requested'

I tried with different procedures and functions - result is the same.

>From the command line python 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;

But another procs do no work too.

These procedures work when I call them within PL/SQL code.

Yout help, suggestions are very, very, very appreciated.


-- 
Best regards,
 alienoid                          mailto:alienoid@is.lg.ua