Home » Applications » Oracle Fusion Apps & E-Business Suite » passing parameters to sqlloader (apps11.5.10)
passing parameters to sqlloader [message #518154] Mon, 01 August 2011 14:00 Go to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

hi,

How to pass parameters to SQL*LOADER control file?

Re: passing parameters to sqlloader [message #518183 is a reply to message #518154] Tue, 02 August 2011 01:18 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What kind of parameters do you have on mind?
Re: passing parameters to sqlloader [message #518194 is a reply to message #518183] Tue, 02 August 2011 02:12 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

i have created one procedure(Insert) with inout parameter.this parameter i have to use in sqlloader program.
Re: passing parameters to sqlloader [message #518198 is a reply to message #518194] Tue, 02 August 2011 02:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does this parameter represent? How will it affect SQL*Loader?

You know, you aren't charged by number of characters you write in your messages. Describe what you are doing and provide as many details as possible.
profiles [message #518207 is a reply to message #518154] Tue, 02 August 2011 02:47 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

how can we use profiles in sql loader program?
Re: passing parameters to sqlloader [message #518295 is a reply to message #518198] Tue, 02 August 2011 23:39 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

Could provide one example(loader script)to pass any parameters?
Re: passing parameters to sqlloader [message #518296 is a reply to message #518295] Wed, 03 August 2011 00:00 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

Hi

Could you please let me know, is there any way to pass parameters (eg. table name or file name) to SQL*LOADER control file (.ctl)

Regards
rajendar
Re: passing parameters to sqlloader [message #518308 is a reply to message #518296] Wed, 03 August 2011 01:18 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Data file name - yes. It is the DATA keyword.

Table name - I don't think so, unless you create a control file dynamically.

See the documentation, it explains all available parameters. They *might* differ between utility versions, so pick yours if 10g is not the one you use.
Re: passing parameters to sqlloader [message #518309 is a reply to message #518308] Wed, 03 August 2011 01:32 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

can we use fnd_profle.value('user_id') in loader program?
Re: passing parameters to sqlloader [message #518315 is a reply to message #518309] Wed, 03 August 2011 02:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, I don't know anything about Oracle Apps. so I have no idea what "fnd_profile.value('user_id')" would be.
Re: passing parameters to sqlloader [message #519760 is a reply to message #518315] Tue, 16 August 2011 13:28 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I doubt that you would get any value for "fnd_profle.value('user_id')" unless you initialize the session with fnd_global.apps_initialize.
Check the following from Oracle Applications Forum GuideQuote:
8. Not able to see the profile option values from back end SQL tools? Have a look at link1 and link2?
If you know the user_id to pass to fnd_global, then why do you want to use fnd_profile.value to get the user_id?

By
Vamsi
Previous Topic: auto lockbox error ora-28115: policy with check option violation
Next Topic: supplier interface
Goto Forum:
  


Current Time: Thu Mar 28 12:55:30 CDT 2024