home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.oracle
- Path: sparky!uunet!haven.umd.edu!darwin.sura.net!jvnc.net!yale.edu!yale!gumby!destroyer!ubc-cs!unixg.ubc.ca!unixg.ubc.ca!fragante
- From: fragante@unixg.ubc.ca (Gv Fragante)
- Subject: Re: Displaying variables in PL SQL
- Message-ID: <fragante.711919063@unixg.ubc.ca>
- Sender: news@unixg.ubc.ca (Usenet News Maintenance)
- Nntp-Posting-Host: unixg.ubc.ca
- Organization: University of British Columbia, Vancouver, B.C., Canada
- References: <1992Jul22.203558.25081@indetech.com>
- Distribution: usa
- Date: Thu, 23 Jul 1992 19:17:43 GMT
- Lines: 17
-
- In <1992Jul22.203558.25081@indetech.com> gopi@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.
-