Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Unanswered: Regd executing sql scripts from shell scripts

    I need to run a .sql script from my shell script.

    For eg. shell script A calls sql script B.sql by passing a parameter. There is a stored proc inside the B.sql which uses this parameter to execute the stored proc by passing this parameter as an input. How can this be done using shell scripts? Any ideas?

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Try using sqlplus in your script:
    sqlplus user/passwd@MyDB @B.sql PARM1

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts