Re: seeing bind variables

this will include "waits".
just for bind variables - level 4.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, April 22, 2003 2:56 PM

> 10046, lev 12.
>
> -----Original Message-----
> Sent: Tuesday, April 22, 2003 1:47 PM
> To: Multiple recipients of list ORACLE-L
>
>
> List,
> how do I see the actual data (bind variables) that this procedure is
trying
> to insert? I have set an event (6502) and got the trace file from that,
so
> I know the package and procedure. Then I enabled sql_trace in the session
> but did not get the actual values like it states in Oracle Note# 139548.1.
> This is 9iRel2 on AIX 64-bit. I have 110 bind variables how do I see them
> all. I deleted some of the insert into statement to save space.
>
> ORA-01401: inserted value too large for column
>
> No changes made to database.
>
> INSERT INTO "HSD_PROFSVC_CLAIM_HEADER" ( "SEQ_CLAIM_ID",
> "CLAIM_NUMBER", "PRIMARY_SVC_DATE", "CLAIM_THRU_DATE",
> "AUTH_NUMBER", "SECONDARY_AUTH", "SEQ_MEMB_ID", "MEMBER_AGE",
> "MEMBER_GENDER", "SEQ_PCP_ID", "PCP_TYPE", "PCP_SPEC", "PCP_IPA_ID",
> "SEQ_GROUP_ID", "PLAN_CODE", "LINE_OF_BUSINESS", "PANEL_ID",
"RIDER_STRING",
>
> "ELIGIBLE_THRU_DATE", "ELIG_STATUS", "SEQ_PROV_ID", "SEQ_PROV_ADDRESS",
> "PROVIDER_PAR_STAT", "PROVIDER_TYPE", "PROVIDER_SPEC", "PROVIDER_IPA_ID",
> "PROVIDER_PCP_FLAG", "SEQ_REF_PROV_ID", ...
> "RELEASE_MED_RECS_IND", "ONSET_TIME", "AUTO_ACCIDENT_STATE",
> "SEQ_COV_PROV_PARENT", "REIMB_METHOD", "PATIENT_PAID_AMOUNT",
> "PROVIDER_PANEL",
> "PROVIDER_IPA", "REF_PROV_PCP", "OC_CARRIER_CODE", "COB_ALWD_AMT_RULE",
> "COB_ALWD_AMT_RSN", "PLACE_OF_SERVICE_2", "PLACE_OF_SERVICE_3",
> "FACILITY_LAB_ID_NO", "SEQ_DFLT_VEND_ID", "SEQ_DFLT_VEND_ADDRESS",
> "AUTH_MATCH_ORDER", "SEQ_PAY_SUB_VEND_ID", "SEQ_PAY_SUB_VEND_ADDR_ID",
> "PROVIDER_POSTAL_CODE", "IN_SERVICE_AREA", "EXPLANATION_ATTACHED",
> "HEADER_CHANGED", "ACCEPT_MEDICARE_ASSIGN_FLAG", "PRIMARY_OC_EXISTS",
> "PAY_DEPENDENT", "INVALID_DATA_IND" ) VALUES
> ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15,
> :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29,
> :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43,
> :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57,
> :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71,
> :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85,
> :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99,
> :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110 )
>
> thanks,
> David Ehresmann
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
> INET: David.Ehresmann_at_ps.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).