Re[3]: [Zope] Help needed: zope + DCOracle2 Stored procedure: Answer is found

Ruslan Spivak Ruslan Spivak <alienoid@is.lg.ua>
Wed, 28 Aug 2002 13:17:48 +0300


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