OraFAQ Forum: Server Administration » Loading data without SQLLDR in a proc

Home » RDBMS Server » Server Administration » Loading data without SQLLDR in a proc

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

Loading data without SQLLDR in a proc [message #54319]

Mon, 11 November 2002 09:11

tma
Messages: 5
Registered: October 2002

Junior Member

Hello,
I would like to know if there is any way to load data files in a stored procedure without shelling out to sqlldr? So I want to be able to load data in my stored proc but I don't want to shell out or use sqlldr, is there like a package or some sort of utility? (My guess is no but I wanted to be sure)

Report message to a moderator

Re: Loading data without SQLLDR in a proc [message #54320 is a reply to message #54319]

Mon, 11 November 2002 09:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

UTL_FILE is an oracle built-in package.
You can read or write data from/to files using this.

Report message to a moderator

Re: Loading data without SQLLDR in a proc [message #54322 is a reply to message #54319]

Mon, 11 November 2002 11:25

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Go ahead as what Mahesh said...But do not Forget to set UTL_FILE_DIR = "Path where u want to keep Flat files/Flat files available" in the Init.ora file.

sai

Report message to a moderator

Previous Topic:	data file block corrupted!!!
Next Topic:	How to import excel or ms access table in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 16:43:40 CST 2024