Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    9

    Unanswered: How to execute a procedure from a shell script

    How to execute a procedure from a shell script

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Create a SQL script that executes the stored procedure
    Create a shell script that calls sqlplus to run that SQL script

  3. #3
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    $ sqlplus -s <user>/<pwd>@<conn> <<EOSql
    > execute <procedure_name>
    > EOSql
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

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