[Zope] Help needed: zope + DCOracle2 Stored procedure

Matthew T. Kromer matt@zope.com
Mon, 26 Aug 2002 13:45:43 -0400


Ruslan Spivak wrote:

>Hello zope users,
>
>Could anybody explain me what is going wrong?
>
>RH7.2 + zope2.5.1 + Oracle9i + DCOracle2
>
>When I try to call stored procedure I get:
>
>Error Type: DatabaseError
>Error Value: (1460, 'ORA-01460: unimplemented or unreasonable conversion requested')
>
>I tried different stored procedures but the result is the same, even
>when I call empty procedure I get the same error.
>
>  
>

My best guess is that your datbase is in a different character set, and 
so you need to set the proper client side environment variables to tell 
how to encode strings.

Take a look at the section on debugging in the documentation; turn on 
tracing with

    export DCO2TRACEFLAGS=255
    export DCO2TRACEDUMP=dco2.tracedump

and the corresponding dump file will perhaps show information useful to 
diagnosing the proble.