massmaharaj Posted January 30, 2013 Report Posted January 30, 2013 do you know how to run a oracle sql or procedure through unix script can you please help
vikuba Posted January 30, 2013 Report Posted January 30, 2013 http://www.dbasupport.com/forums/showthread.php?14862-Calling-a-PL-SQL-procedure-from-UNIX
vikuba Posted January 30, 2013 Report Posted January 30, 2013 sqlplus <<ENDOFSQL connect <username>/<password> select * from dual; exit ENDOFSQL
vikuba Posted January 30, 2013 Report Posted January 30, 2013 http://www.dbforums.com/oracle/1633895-controlling-pl-sql-procedure-execution-unix-shell-script.html http://www.unix.com/unix-dummies-questions-answers/37408-running-pl-sql-procedure-via-unix.html http://forums.devshed.com/unix-help-35/running-sql-quiries-from-unix-shell-scripts-186488.html
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 please be sure to not to show password in the script! environment variables tho edho set chestharu password kanabadakunda undadaniki
vikuba Posted January 30, 2013 Report Posted January 30, 2013 thread esinodu kaneesam..solve aindhoo ledhoo kuda cheppakapotey ela vaay. ninna edo thread lo annatu.. 90% db ppl use and throw type anattu untaaru ani... looks like it is true
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [quote name='Aamphat' timestamp='1359569789' post='1303202003'] thread esinodu kaneesam..solve aindhoo ledhoo kuda cheppakapotey ela vaay. ninna edo thread lo annatu.. 90% db ppl use and throw type anattu untaaru ani... looks like it is true [/quote] busy undi untaadu le baa, update chesthaadu le aagu
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 ledhu baa inka working daani meedh adhi work kaaledhu nenu alantivaadini kaadhu baa ala anukovaaddu please
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 try this baa $ORACLE_HOME/bin/sqlplus -s USERID/password@"database" @"your store proc"
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 #!/usr/bin/ksh #set -x sqlplus <<ENDOFSQL connect <username>/<password> select * from dual where filter criteria ; exit ENDOFSQL
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 i used the above eerror is /Scripts/proc.ksh[3]: sqlplus: not found
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [color=#282828][font=helvetica, arial, sans-serif]$ORACLE_HOME define ayyi undha??[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]echo [/font][/color][color=#282828][font=helvetica, arial, sans-serif]$ORACLE_HOME ante em vastondhi?[/font][/color]
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 <p> [b] [url="http://www.andhrafriends.com/user/9184-jaffanajeffada/"]jaffanajeffada[/url][/b] [color=#5A5A5A][font=helvetica, arial, sans-serif][size=3][center][background=rgb(237, 240, 244)] [color=#777777][size=3] Celebrity[/size][/color][list] [*][url="http://www.andhrafriends.com/user/9184-jaffanajeffada/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-9184.png?_r=0[/img][/url] [*]Members [*][img]http://www.andhrafriends.com/public/style_extra/team_icons/celebrity_afdb.png[/img] [*]6,711 posts [/list][color=#5A5A5A][font=helvetica, arial, sans-serif][size=3] [color=#A4A4A4][size=3][background=rgb(147, 200, 135)] Posted 30 January 2013 - 08:56 PM[/background][/size][/color][color=#282828][size=4] try this baa $ORACLE_HOME/bin/sqlplus -s USERID/password@"database" @"your store proc"[/size][/color][/size][/font][/color][/background][/center][/size][/font][/color] the below is the error which i tried for this /proc1.ksh[3]: /apps/orcl01/oracle/product/11.2.0/client_1/bin/sqlplus: not found t
Recommended Posts