PowerBuilder - Oracle 7.3.3.0.0 problem

Hi

I am facing a problem. Please help.

Following PowerBuilder(4.0 or 6.0) code works in Oracle v7.3.2.1.0 but fails in Oracle v7.3.3.0.0

v_test dec{6}
select 10/94.567 into v_test from dual;
<= fail

select months_between(sysdate,to_date('15-Jun-98'))

    into v_test from dual;
<= fail

select 10.5467 into v_test from dual;
<=success

What I found out is, when some calculation which returns float value is done in 'select' statement, it gives error in Oracle v7.3.3.0.0, but works in Oracle v7.3.2.1.0.

The error which I get is sqlerr = -1; sqldberr = -2; sqlerrtext =
<=nothing

The code works in Oracle v8.0.3.0. But fails in all versions of v7.3.3.0.0. I tried on v7.3.3.6.0 also, but still it gives same problem.

This is a very specific problem. Same kind of code in PL/SQL works perfectly. Both PL/SQL and PowerBuilder connect to backend Oracle using same SQL*NET.

Any kind of help on this is appreciated. Thanks in advance
Ashish Received on Sun Jun 28 1998 - 10:58:27 CDT