Re: sqlplus execute cmd

On Wed, 27 Nov 2002, meinhfxGARBAGE_at_hotmail.com wrote:
> I have a script which basically does this:
>
> sqlplus $username/$password @plsql_spec
> sqlplus $username/$password @plsql_body

These lines are command-line invocations.

> I would then like to do
>
> sqlplus $username/$password execute plsql_spec.proc_1

You seem to think that typing sqlplus at the command-line is the same as being at the sqlplus prompt. Typing it puts you at the sqlplus command prompt. What you typed is being evaluated by the command prompt not sqlplus.

Create a file with the line "execute plsql_spec.proc_1;", call it doit.sql. Then your command line will be,

  sqlplus $username/$password @doit

-- 
Galen Boyer