ora-01008 / ora-00932 unexplainable errors

From: <sminni_at_giascl01.vsnl.net.in>
Date: 1998/02/14
Message-ID: <6c3rkd$ck5$1@nnrp2.dejanews.com>#1/1

Hi,

using Oracle 7.1.3.3.3 SQL*net 2.3.2.x.x & Sql*worksheet

I keep getting the following errors

    ORA-01008 Inconsistent Datatype
    ORA-00932 Not all variables bound
  when I define Bind (substitution ) variables

The errors and situation is unpredictable. In fact merely altering the order of columns seems to remove the problem !

I reproduce a section of the code :
error :

SQLWKS> select ( :arg_start_date - sysdate ) d1,
     2>        ( :arg_start_date - sysdate ) d2,
     3>        ( :arg_stop_date - sysdate ) d3
     4> from dual
     5>

ORA-00932: inconsistent datatypes
but this works !:

SQLWKS> select ( :arg_start_date - sysdate ) d1,
     2>        ( :arg_stop_date - sysdate ) d2,
     3>        ( :arg_start_date - sysdate ) d3
     4> from dual
     5>
D1         D2         D3

---------- ---------- ----------

1 row selected.
Note : the only difference is that position of column d2 & d3 is interchanged

The error message varies between 00932 & 01008

Any help will be appreciated as some of our vital reports are help up. Pl mark a copy directly to me - sminni_at_giascl01.vsnl.net.in

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Feb 14 1998 - 00:00:00 CST