How to execute procedure from unix command line 2

[marrow]

In oracle9, I have compiled oracle procedure "CREATE OR REPLACE EXTRACT_FILE1 AS ...."
I can run OK if
sqlplus /nolog
>connect user1/user1@database1
>execute EXTRACT_FILE1

But not sure how to use short form...
Can I initiate the execute from unix on single line?
sqlplus user1/user1@database1 .....?????

 

[LKBrwnDBA]

You need to put the "execute EXTRACT_FILE1..." in an sql script file.

echo "execute EXTRACT_FILE1;" > mysql.sql
echo "exit" >>mysql.sql
sqlplus user1/user1@database1 @mysql.sql




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[stefanhei]

Or pass the command to sqlplus via pipe:

echo 'execute extract_file' |sqlplus usr/passwd

Have a look at faq186-2220 for a more detailed description.

Stefan

 

[marrow]

Thanks Stefanhei & LKB, works a treat.