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!

SqlLoader Pass the Parameter as a schema name

selvi mJan 9 2023 — edited Jan 10 2023

Hey Team!
In sql loader control scripts, I must supply the parameter &6 as the schema name before the table name (it looks like &6. bio currency). Although the details were scheduled in CA7 and the sql loader control scripts parameter was set to &6, it was unable to pass.
Please advise.

Code
LOAD DATA
REPLACE
INTO TABLE &6.bio_currency
TRAILING NULLCOLS
(
country Position(1:18) char(18),
sub_code Position(19:23) char(5),
qty1 position(24:29) Integer External(6)
)

Thanks

Comments

Post Details

Added on Jan 9 2023
6 comments
354 views