Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Jan 9 2023
#general-database-discussions, #plsql, #sqldeveloper, #sqlplus
6 comments
334 views