Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problems with Oracle Trace
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