Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Examining Host Variables
On Tue, 1 Sep 1998 15:50:12 +0100, "Boo" <Boo_at_boogie-the-cat.demon.co.uk>
wrote:
>Dear All,
>
>Does anyone know how to examine the contents of SQL host variables in
>programs that use the Oracle precompiler.
>
>I have a SQL statement in a PRO*COBOL program that utilises input host
>variables. When I examine the SQL using V$SQLAREA, only the host variable
>name is displayed. I need to know what value has been assigned to the host
>variable.
>
>Altering the program to output the values is not an options as the code is
>generated !
>
>
>Thanks
>
>Peter
>
>
>
>
If you compile and run the program in debug mode, you should be able to see them.
Eric Received on Sat Sep 12 1998 - 11:41:52 CDT