bind variable and shell scripting with sqlplus

Question

I wish to execute DMLs using bind variable with shell scripts. For example, something like:

#!/bin/bash

SH_NUM=10

sqlplus -S test_user/test_pass <<EOD
var a number;
a:=${SH_NUM}
insert into test_table values(a);
commit;
EOD

I'm not sure if this is possible, I can use this approch when using pl/sql but I wish to know if I can do it this method as well.

Answer 1

Problem is the assigment line, it should be changed to:

exec :a :=${SH_NUM};