Load tables with text file

[ofsouto]

A Visual Basic application opens a text file (client machine), reads line to line and loads a table.
I want to know if it´s possible to create a stored procedure (or another object) to execute this function and How can I do this?
Oracle 8i (release 8.1.7)

 

[sem]

Of course, you may pass the content of your text file as VARCHAR2 or CLOB to some procedure, but why don't you use SQL*LOADER?

 

[ofsouto]

I thought about a procedure that opens and processes a text file.
Is it possible to execute SQL*LOADER from Visual Basic?

 

[sem]

Yes, you may call sql*loader as you may run any program. As for reading file from procedure, you may use UTL_FILE package, but in this case your file should be "visible" from Oracle server, not from client.

 

[charudattas]

Great, I have a great answer for you.
It is possible to run loader from VB. But why involve one more tool. Use UTL_FILE package. This package helps you read and write OS files. Call this from a procedure while passing file to this procedure. IF any probs write me.

 

[sem]

UTL_FILE is suitable for reading SMALL TEXT FILES only and its executed on server. You can not even open a file without knowing its name, even if it's the only file in directory.

 

[ofsouto]

Could you show me an visual basic example calling sql*loader?