Hi unixers,
Anyone have any links or online tutorials for Shell Scripting with respect to Oracle .
Any example of script calling any Oracle procedure or function or passing parameters is highly appreciated.


















cheers
RRK

Why you leave space after your message until cheers, you can put your regards immediately after your message, sorry, no offense meant here, only to remind you if you are doing it out of habit, save the space and planet

wht do u want to know abt oracle..
its something like configuration of MT's & DB's or wht type.. first try to master shell script & oracle ... n u are the geek u can work of ur own...

hmmm not really sure that answer is going to help much... sounds a bit rude too!

Anyway, you might want to try searching the forums here. There have been a few posts about this topic already. Here are a couple of useful posts

shellscript.query Oracle table..populate in a text file

how to return an array of elements from oracle to shell script

Connecting to Oracle from Shell..What Am I doing Wrong

and of course there is always google

Hope this helps!

ho! sorry.. if my answer was rude.. plz try to master shell scripts.. i saw few documents in this forum.. wow it was fentastic. why dont u get it.. All the best..

I think that you want to call this via a language in the middle. This way it is more controllable. Please have a look at ways to call functions and stored procedures from a shell script via a small Perl program or C program.

A good reference is http://www.orafaq.com/faqperl.htm



Regards,
Johan Louwers. http://www.terminalcult.org