Saturday, January 14, 2006

Oracle: bind variables and ksh

#!/bin/ksh

function f
{
sqlplus -s < login/passwd@db
var v1 varchar2(10);
var v2 varchar2(10);
exec :v1 := '$1';
exec :v2 := '$2';
exec pkg.prc(:v1, :v2);
EOF
}

f A B

posted by James Pei @ 3:40 PM

0 Comments:

Post a Comment

<< Home