Re: sqlplus execute cmd

In article <3de50d10.18786725_at_news.dal.ca>,  meinhfxGARBAGE_at_hotmail.com (tony) wrote:

>I have a script which basically does this:
>
>sqlplus $username/$password @plsql_spec
>sqlplus $username/$password @plsql_body
>
>I would then like to do
>
>sqlplus $username/$password execute plsql_spec.proc_1
>
>This gives me a sqplus command error showing that execute is not an
>option. Within sqlplus execute plsql_spec.proc_1 works fine. Any
>idea how I can work around this?

sqlplus $username/$password <<EOF
execute plsql_spec.proc_1
EOF (that technique is called "here file")

or

sqlplus $username/$password @proc_1

and proc_1.sql contains the following to lines <--
execute plsql_spec.proc_1
exit
-->

Greetings from Switzerland -- Gruesse aus der Schweiz Happl Received on Wed Nov 27 2002 - 13:23:11 CST