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>


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

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


-------------------------------------------------------------------------------
| alain_at_mais.hydro.qc.ca
-------------------------------------------------------------------------------
Received on Fri Mar 19 1993 - 16:38:29 CET

Original text of this message