Skip to Main Content
Forums

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!

Calling Unix-Script from within Oracle and store stdout/stderr in table

493926Feb 27 2006 — edited Mar 2 2006
Hi,

What I want to do is:


1. Calling a UNIX script (e.g. hello.sh) (from inside the Database)

hello.sh
echo “Hello World!“

2. and get the stdout/stderr output back in my Database in a table (e.g. temp_back)

table temp_back
ID stdout stderr
1 Hello World!

I think Number 1 isn’t a big problem, but how to get stdout back in DB?

Any solution?

I searched a bit in this Forum and found this Post.
200919
This may be what I am searching for, but can’t access the Link


Since I am not really fit with UNIX and packages/procedures in Oracle it would be nice if you could post a very detailed answer.
(Please no java)

-What packages do I need? (heard DBMS_OUTPUT would be useful)
-example PL/SQL script

Thanks a lot!
Marcus


Environment:
Oracle 9.2.0 DB
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2006
Added on Feb 27 2006
7 comments
1,039 views