Home » RDBMS Server » Server Utilities » Using user-defined stored functions in SQL*Loader DIRECT path (Oracle 10g, Unix AIX)
Using user-defined stored functions in SQL*Loader DIRECT path [message #420879] Thu, 03 September 2009 00:18 Go to next message
singhabhijitkumar
Messages: 7
Registered: February 2008
Location: india
Junior Member

Hi, can I use user-defined functions in my sql*loader control file and load in DIRECT path mode?
Re: Using user-defined stored functions in SQL*Loader DIRECT path [message #420882 is a reply to message #420879] Thu, 03 September 2009 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What happened when you tried it?

Regards
Michel
Re: Using user-defined stored functions in SQL*Loader DIRECT path [message #420889 is a reply to message #420882] Thu, 03 September 2009 01:35 Go to previous messageGo to next message
singhabhijitkumar
Messages: 7
Registered: February 2008
Location: india
Junior Member

Michel Cadot wrote on Thu, 03 September 2009 00:35
What happened when you tried it?

Regards
Michel


do we get answers on this forum?
Re: Using user-defined stored functions in SQL*Loader DIRECT path [message #420890 is a reply to message #420889] Thu, 03 September 2009 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
do we get answers on this forum?

Yes but it is not here to make your work and prevent from doing any effort like reading the documentation or makinh a small test.

In addition, if I answer "yes", what do you do? Making in production something you did not test yourself? And if I answer "no", will you not test anyway to see if I am not wrong?

Regards
Michel
Re: Using user-defined stored functions in SQL*Loader DIRECT path [message #420899 is a reply to message #420890] Thu, 03 September 2009 02:50 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Furthermore, if Michel answered "Yes, it is possible" and someone else (for example, me) answered "No, it is not possible", who would you believe? Michel or me? Or would you rather test it yourself?
Re: Using user-defined stored functions in SQL*Loader DIRECT path [message #421103 is a reply to message #420899] Fri, 04 September 2009 04:20 Go to previous message
singhabhijitkumar
Messages: 7
Registered: February 2008
Location: india
Junior Member

hey, thanks
Previous Topic: AP Supplier Import
Next Topic: IMP-00019 error while importing
Goto Forum:
  


Current Time: Wed Sep 28 21:11:30 CDT 2016

Total time taken to generate the page: 0.24950 seconds