This content has been marked as final. Show 8 replies
Create a shell Script(Unix) or Windows batch Job to automate the entire process. The script will like below
1.Connect SQLPLUS with the Createtable.SQL file (The Createtable.sql will have the create table script)
2.invoke sql loader with the control file
3.then again connect SQLPLUS with the executeproc.sql file (the executeproc.sql will have the execute command to execute the stored procedure)
by this way your entire process can be in one script and automate by scheduling it in unix or windows.
Edited by: Vijayaraghavan Krishnan on Nov 27, 2012 4:48 PM
966949 wrote:you were asked for TWO required details & yet you provide only 1 answer
We are using oracle 11g.
Status Level: Newbie
Registered: Oct 22, 2012
Total Posts: 54
Total Questions: 10 (8 unresolved)
so why am I not surprised by above?
BTW, in your original post you spelled "INTO" incorrectly.
is COPY & PASTE broken for you?