SQL Error - Data Type Has Changed?

["C. Duncan Hudson" <c_duncan_hudson@YAHOO.COM>]

Hi,


I need help.  I've written a program, using SQR 4, that reads two
Oracle tables and builds a flat file.  I begin by selecting records
from one table, and then use the returned values (&invoicenum) to
query the second table.  My second query (below) is returning an error
about midway through the program (an error listing follows the code),
after having successfully executed several times.  I've taken the
offending SQL statement (with the variables that erred) and pasted it
into SQL Plus and the query works fine.  I'm at a loss as to what's
causing the error.  Can anyone give me a hand?  Thanks in advance,


Dunc.

...................................................

{snip}

begin-select on-error=error_proc(4.1)
gldebitacct                       &debitacct
glcreditacct                      &creditacct
to_char(trunc(linecost * 100))    &linecost
linecost                          &cost
percentage                        &percentage
    let #total_allocated = #total_allocated + &cost
    do build_distribution
from {schema}invoicecost
where invoicenum = &invoicenum
end-select

{snip}

begin-procedure error_proc (#source)
evaluate #source
when < 5 ! Invoice Select
let #_return-status = 67
display 'Invoice = ' noline                        display &_invoicnum
display 'Status = ' noline
display #source
display 'Error selecting invoices'
display 'SQL-Status = ' noline
display #_sql-status
display 'SQL-Error = ' noline
display $_sql-error
stop quiet
break

{snip}

.........................................

Invoice = 1011
Status = 4.100000
Error selecting invoices
SQL-Status = 0.000000
SQL-Error = [INTERSOLV][ODBC Oracle driver]Data type for parameter 1
has changed since first SQLExecute call.


_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com