CODEWITHSUNDEEP
oracle-databaseoracle11gsql-loader
Ransom Briggs
Ransom Briggs

Reputation: 3085

Is there a way to call SQL before SQL*Loader imports?

I am using sqlldr to do a bulk load of data, but I need to set a context value before the data loads so that a trigger has a value, but I cannot find a way to execute arbitrary sql as part of a data load.

Upvotes: 1

Views: 348

Answers (1)

David Aldridge
David Aldridge

Reputation: 52346

In theory an after logon trigger can run code for you, but it would be difficult to switch functionality like that on and off on demand.

Consider using an external table instead of SQL*Loader, and you can do just about whatever you like as part of the session.

Upvotes: 1

Related Questions