Using variable withing shell scripts for calling Oracle DB procedures

From: Swapan Dutta <swapandutta_at_yahoo.com>
Date: 26 Sep 2001 18:14:19 -0700
Message-ID: <d220f943.0109261714.3fe7768a@posting.google.com>

Hello :
I want to pass variables to oracle procedures. I tried the following script, but it failed.

---

#!/bin/sh
first_var='value'
sqlplus -s username/password_at_connect <<END

    execute package.proc($first_var,'two','three'); END exit 0

---

If I replace $first_var in the execute statement by a static string, the script works. What is the syntax for passing variables within shell script to oracle procedure?

Thanks in advance.

• Swapan.

Received on Wed Sep 26 2001 - 20:14:19 CDT