file I/O operations

[potti]

hi I am new to this group.can u pl help me in using file I/O operations,when i try to fetch data from flat file to table it is giving message like"invalid path directory".Is it necessary to have access on that directory?which one is better to fetch data from external file SQLLOADER or fopen() ?pl give syntax for fopen().

[debasisdas]

use the predefined package ----------- UTL_FILE

[potti]

use the predefined package ----------- UTL_FILE

hi debasis, thanks for ur prompt response.when I am using the UTL_FILE package only it is giving error like 'Invalid directory path name' when i try to give the path of that file.what to do?

[debasisdas]

Can u kindly post your code please.

[Saii]

you can SQLLOADER for the same. That does not require you to create any directory object.
If you use UTL_FILE, then you need to create a directory object to specify the location of file.

[frozenmist]

Hi Saii,
How can I contact you? You have disabled PM and email, That is why...

[sphanimohan]

Hi....
If you want know about UIL_FILE,
here is the path

http://www.oreilly.com/catalog/oraclebip/chapter/ch06.html

may it will help you.

[potti]

Hi....
If you want know about UIL_FILE,
here is the path

http://www.oreilly.com/catalog/oraclebip/chapter/ch06.html

may it will help you.

Thanks phanimohan,this site is of great help for me

[Saii]

Hi Saii,
How can I contact you? You have disabled PM and email, That is why...

hi,

u can post the questions here

[frozenmist]

Hi Saii,
Its not a question. Would you be interested in taking up responsibility as an expert?
Please do reply
Cheers