Re: Displaying variables in PL SQL
From: Gv Fragante <fragante_at_unixg.ubc.ca>
Date: Thu, 23 Jul 1992 19:17:43 GMT
Message-ID: <fragante.711919063_at_unixg.ubc.ca>
Date: Thu, 23 Jul 1992 19:17:43 GMT
Message-ID: <fragante.711919063_at_unixg.ubc.ca>
In <1992Jul22.203558.25081_at_indetech.com> gopi_at_indetech.com (Prakash Gopinath) writes:
>I am using Oracle ver 6.0. I want to display variables used in PL SQl onto the console.
>Is it possible?
>Please help!
>Thanks
>Gopinath
Use the Message() function. As in MESSAGE(:GLOBAL.MY_VARIABLE). If you want to display a numeric variable, use the TO_CHAR() function as in MESSAGE(TO_CHAR(:GLOBAL.MY_NUM_VARIABLE)). Use Message() to display :SYSTEM, :GLOBAL and local variables. YOu can string variables together so that you can see them in one MESSAGE() command. Received on Thu Jul 23 1992 - 21:17:43 CEST