Negative number fetch in pl/sql
From: Alain Turcotte <alain_at_mais.hydro.qc.ca>
Date: Fri, 19 Mar 1993 15:38:29 GMT
Message-ID: <alain.732555509_at_tdsb-s>
| alain_at_mais.hydro.qc.ca
Date: Fri, 19 Mar 1993 15:38:29 GMT
Message-ID: <alain.732555509_at_tdsb-s>
Hi
I would like to know why i can not fetch a negative number in a pl/sql variable when that variable use the same format as in the database, i.e. i have the following variable :
piezo_suivant NUMBER(6,3);
which has the same format as in the database and the database contains the value -130.159 but at the :
FETCH niveau_piezo_suivant INTO piezo_suivant;
i get the following message "trigger raised unhandled exception VALUE_ERROR"
thank in advance for any answer
| alain_at_mais.hydro.qc.ca
| Alain Turcotte (514-858-7718 ) | Hydro-Quebec | 140 Cremazie ouest | Montreal
-------------------------------------------------------------------------------
--Received on Fri Mar 19 1993 - 16:38:29 CET
-------------------------------------------------------------------------------
| alain_at_mais.hydro.qc.ca
-------------------------------------------------------------------------------