S.R.Anantha Rao's Page

Hi All,



We have an requirement for Oracle apps,



We have different applications and each application contains various concurrent programs running and located at different servers.our requirement is to display the errored out concurrent program in Web.



The requirement1 is I will write query to get the failed programs and insert into the files by comma separation.then this file will be read by my shell script which contains the server,username,password,log file… Continue

Hi All,

I just want to know , if the Pl/SQL procedure is located at one database server , can I call a shell script located at other server.
If so, can anyone please let us know how it can be done.
and also can we pass parameters to the procedure or script can return values.
Anything which can be added will be great.


Thanks in advance.

I have one requirement, we are making web-based monitor for the concurent job which gets failed so that the log file will be available in front end.



our requirement is,

Assume if any job gets failed with some request-id, We will take this request-id as Input parameter and we will navigate to unix server where the log is stored and we will read the log file and insert into the table in one column.



Any anyone help how this can be achieved. Any help is highly… Continue