Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader-291: Invalid bind variable

aantonApr 2 2008 — edited Apr 2 2008
I am getting thje above error message. Header and detail from input are loaded into 2 tables. SRCSYS_ACRONYM is loaded into the header and I am trying to use this in the detail table...any help ?

LOAD DATA
INFILE 'c:\f.txt'
--
--
INTO TABLE STAGING_HEADER
WHEN (record_type_code = '0')
( STAGING_HEADER_ID SEQUENCE(max,1),
RECORD_TYPE_CODE position(1:1) char,
SRCSYS_ACRONYM position(2:6) char "upper(:SRCSYS_ACRONYM)",
-- PROCESS_DATE position(7:14) "to_date(:process_date,'yyyymmdd')",
DATE_TIMESTAMP position(7:22) "to_timestamp(:DATE_TIMESTAMP,'yyyymmddhhmissff2')",
HDR_PRD_START_DATE position(23:30) "to_date(:HDR_PRD_START_DATE,'yyyymmdd')",
HDR_PRD_END_DATE position(31:38) "to_date(:HDR_PRD_END_DATE,'yyyymmdd')",
create_date sysdate,
create_userid constant "xxxx",
update_date sysdate,
update_userid constant "xxxx"
)
--
--
INTO TABLE STAGING_DETAIL
WHEN (record_type_code = '1')
( MAR_STAGING_DETAIL_ID sequence(max,1),
RECORD_TYPE_CODE POSITION(1:1) CHAR,
SRCSYS_ACRONYM_D char(5) "decode(:SRCSYS_ACRONYM,'ODRSP','RSP','FRSLT',(DECODE(:CORP_CODE,'RDAM1','AMICUSM','MTG')),'LESPL','LE',:SRCSYS_ACRONYM)",
CUST_GRP_NUM POSITION(2:6) CHAR,
CORP_CODE POSITION(7:11) CHAR,
BR_OF_ACCT_NUM POSITION(12:16) CHAR,
PRODUCT POSITION(17:20) CHAR,
ORG_UNIT_ID POSITION(21:25) CHAR,
GLM_ACCT_NUM POSITION(26:32) CHAR,
CURR_IND POSITION(33:33) CHAR,
CURR_CODE POSITION(34:37) CHAR,
SUB_ACCT_NUM POSITION(38:40) CHAR,
BALANCE_TYPE_IND POSITION(41:41) CHAR,
AVERAGE_BALANCE_AMT POSITION(42:56) CHAR,
TRANSFER_PRICE_RATE POSITION(57:61) DECIMAL EXTERNAL,
BALANCE_SIGN POSITION(62:62) CHAR,
CERTIFICATE_NUMBER POSITION(63:104) CHAR,
create_date sysdate,
create_userid constant "XXXX",
update_date sysdate,
update_userid constant "XXXX"
)


SQL*Loader-291: Invalid bind variable :SRCSYS_ACRONYM in SQL string for column SRCSYS_ACRONYM_D.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2008
Added on Apr 2 2008
3 comments
6,226 views