请问 我怎么在 shell 中与plsql 语句实现 交互的效果呢 ?
比如,
linux#./test.sh
please input a the empno:这个地方我输入工号
然后 read a ,把这个变量接收,但我不知道怎么把这个变量传递给PLSQL去处理
selectempno,sal from emp where empno = &en;
lastwinner 发表于 2012-5-29 01:58
你的PLSQL具体是怎么个表现形式?
#!/bin/bash
echo "please input sec_code:"
read aa
su - oracle-c "sqlplus test/1234<<EOF
set serverout on
spool /opt/oracle/a.txt;
create procedure abc
declare
v_ename varchar2(5);
v_salnumber(7,2);
begin
select ename,sal into v_ename,v_sal from scott.emp where empno=&bb;
dbms_output.put_line('the user is :'||v_ename|| ',whoissal is :'||v_sal);
end;
/
spool off;
exit
EOF"