Hello Ruslan, Tuesday, August 27, 2002, 11:47:53 AM, you wrote: RS> Hello Matthew, RS> Monday, August 26, 2002, 8:45:43 PM, you wrote: MTK>> 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.
MTK>> My best guess is that your datbase is in a different character set, and MTK>> so you need to set the proper client side environment variables to tell MTK>> how to encode strings. MTK>> Take a look at the section on debugging in the documentation; turn on MTK>> tracing with MTK>> export DCO2TRACEFLAGS=255 MTK>> export DCO2TRACEDUMP=dco2.tracedump MTK>> and the corresponding dump file will perhaps show information useful to MTK>> diagnosing the proble. I don't know exactly why it is so but: my former function definition: create or replace function foo(p in varchar2) return BINARY_INTEGER is begin return 1; end; After changing BINARY_INTEGER into NUMBER everything began to work, so new look: create or replace function foo(p in varchar2) return NUMBER is begin return 1; end; works fine! Best regards, Ruslan mailto:alienoid@is.lg.ua