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 -> Problems with Oracle Trace

Problems with Oracle Trace

From: FireHawk <dba_at_freemail.com.br>
Date: Thu, 12 Nov 1998 13:51:21 -0200
Message-ID: <72f05s$9gu$1@usenet41.supernews.com>


When I make a Oracle trace (alter session set sql_trace=true) the output is any as:
SELECT CORP,HOUSE,CUST,EQP_TABLE_CODE
FROM CUST_OUTLET
WHERE HOUSE=NVL(:b1,' ')AND CUST=
NVL(:b2,' ')
But, I don't need the b1 and b2 parameters. I need the contents of b1 and b2.
That is to say, an output like this:
SELECT CORP,HOUSE,CUST,EQP_TABLE_CODE
FROM CUST_OUTLET
WHERE HOUSE=NVL('01010 )AND CUST=
NVL('010').
Can any help me. please??
It's very important for me.
Thank's a lot.

Then, I need the contents of variables. Received on Thu Nov 12 1998 - 09:51:21 CST

Original text of this message

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