OraFAQ Forum: SQL & PL/SQL » Load data into a table via a stored proc.

Home » SQL & PL/SQL » SQL & PL/SQL » Load data into a table via a stored proc.

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

Load data into a table via a stored proc. [message #38027]

Thu, 14 March 2002 05:52

Dan
Messages: 61
Registered: February 2000

Member

With Oracle v7.3 is there a way to call a stored procedure that will invoke SQL*Loader and load data from a csv file into a table.

Report message to a moderator

Re: Load data into a table via a stored proc. [message #38029 is a reply to message #38027]

Thu, 14 March 2002 06:10

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

u can not call the SQL*Loader from stored procedure .

Report message to a moderator

Re: Load data into a table via a stored proc. [message #38033 is a reply to message #38027]

Thu, 14 March 2002 07:17

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

u can use utl_file package to read the csv file and load data

Report message to a moderator

Re: Load data into a table via a stored proc. [message #38036 is a reply to message #38027]

Thu, 14 March 2002 10:12

Grant
Messages: 578
Registered: January 2002

Senior Member

Yes you can invoke sqlloader via external procedure calls. If you do a search on MetaLink for "external procedure sqlloader" you find some good examples.

Report message to a moderator

Previous Topic:	Datmodeling
Next Topic:	Granting packages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 09:03:04 CDT 2024