Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Examining Host Variables

Re: Examining Host Variables

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Sat, 12 Sep 1998 16:41:52 GMT
Message-ID: <35f7eb78.608406775@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US