Question
=========
Enabled 10046 Trace Level 4 and created Trace Files, Buth How To Find Bind Variables's Value
EOS (End of Section)
Answer
=======
Here is an esample:
Sample PL / SQL Code:
Declare
Vcount Number: = 88;
vcount2 char (5): = 'meme';
Begin
INSERT INTO TABA VALUES (VCOUNT, VCOUNT2);
END;
The resulting trace output:
PARSING IN CURSOR # 2 LEN = 36 Dep = 1 UID = 0 OCT = 2 LID = 0 TIM = 0 HV = 540755502
AD = '40106
C6c '
INSERT INTO TABA VALUES (: B1,: B2)
End of stmt
PARSE # 2: C = 0, E = 0, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 0
BINDS # 2:
BIND 0: DTY = 2 mxl = 22 (22) MAL = 00 SCL = 00 pre = 00 oacflg = 03
BFP = 20080d30 BLN = 22 AVL = 02 FLG = 05
Value = 88
BIND 1: DTY = 96 mxl = 32 (05) MAL = 00 SCL = 00 pre = 00 oacflg = 03
BFP = 20080d1c BLN = 05 AVL = 05 flg = 05
Value = "MEME"
EXEC # 2: C = 0, E = 0, P = 0, Cr = 2, Cu = 3, MIS = 0, R = 1, DEP = 1, OG = 4, TIM = 0
EXEC # 1: C = 0, E = 0, P = 0, Cr = 2, Cu = 3, MIS = 0, R = 1, DEP = 0, OG = 4, TIM = 0
XCtend RLBK = 0, RD_ONLY = 0
: b1's value is bind 0, value = 88
: B2'S Value Is Bind 1, Value "MEME"
