Oracle-L: seeing bind variables

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Tue, 22 Apr 2003 09:47:03 -0800
Message-ID: <F001.00586FDB.20030422094703@fatcity.com>

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).

Received on Tue Apr 22 2003 - 12:47:03 CDT