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

    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
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Try using sqlplus in your script:
    Code:
    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
  •