OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » passing parameters to sqlloader

Home » Applications » Oracle Fusion Apps & E-Business Suite » passing parameters to sqlloader (apps11.5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

passing parameters to sqlloader [message #518154]

Mon, 01 August 2011 14:00

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

hi,

How to pass parameters to SQL*LOADER control file?

Report message to a moderator

Re: passing parameters to sqlloader [message #518183 is a reply to message #518154]

Tue, 02 August 2011 01:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What kind of parameters do you have on mind?

Report message to a moderator

Re: passing parameters to sqlloader [message #518194 is a reply to message #518183]

Tue, 02 August 2011 02:12

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.

Report message to a moderator

Re: passing parameters to sqlloader [message #518198 is a reply to message #518194]

Tue, 02 August 2011 02:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

profiles [message #518207 is a reply to message #518154]

Tue, 02 August 2011 02:47

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

how can we use profiles in sql loader program?

Report message to a moderator

Re: passing parameters to sqlloader [message #518295 is a reply to message #518198]

Tue, 02 August 2011 23:39

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

Could provide one example(loader script)to pass any parameters?

Report message to a moderator

Re: passing parameters to sqlloader [message #518296 is a reply to message #518295]

Wed, 03 August 2011 00:00

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

Report message to a moderator

Re: passing parameters to sqlloader [message #518308 is a reply to message #518296]

Wed, 03 August 2011 01:18

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: passing parameters to sqlloader [message #518309 is a reply to message #518308]

Wed, 03 August 2011 01:32

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

can we use fnd_profle.value('user_id') in loader program?

Report message to a moderator

Re: passing parameters to sqlloader [message #518315 is a reply to message #518309]

Wed, 03 August 2011 02:01

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: passing parameters to sqlloader [message #519760 is a reply to message #518315]

Tue, 16 August 2011 13:28

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 09:10:46 CST 2024