SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we able to call .bat file from Stored procedure?

HulkJul 26 2012 — edited Jul 26 2012

My actual requirement is to import an csv file(where it contains a table) into oracle Database from the front end screen when the csv file location is given.
Where in the screen (designed by dotnet) a browse option will be present and I will give the csv file location and this will be passed into stored procedure as an input parameter.
Now I need a stored Procedure that can Import my csv file table data into Oracle database10g.
I shoudnot use the import option present in the physical Oracle Database.
Can any one please provide me the stored Procedure?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2012

Added on Jul 26 2012

7 comments

1,344 views