Re: How Do I make the Call Command Wait to finish processing an Oracl e called procedure before executing the next line in the SQR program

[Arun Kumar <arunkumar13@YAHOO.COM>]

you will answer if you do a search on the archieve of
this site. I am sure solution is in there.


--- "Mayfield, Cathy" <cmayfiel@INGR.COM> wrote:
> I am running the following code which calls on a
> .BAT file that runs SQLLDR to insert data into a
> table then uses a called Oracle procedure to update
> the records inserted:
>
> ........
>
> let $TIMESTAMP =
> edit($current-date,'yyyymmddhh24miss')
>     let $cmdline = 'g:\TEST\LOAD.bat
> username/password@database g:\TEST'||' '||$timestamp
>
> call system using $cmdline #dos_status
>
> begin-sql
>       begin
>         data_update;;
>       end;;
> end-sql
> ............
>
> The problem is the .BAT is still running loading the
> data but the program still jumps ahead and to the
> part of the procedure that calls the stored
> procedure DATA_UPDATE.
>
> How can I use the WAIT parameter in NT and Windows
> 2000 to halt the program until the .BAT is finished?
>
>
> cmayfiel


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com