17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> set serveroutput on;
SQL> CREATE OR REPLACE PROCEDURE query_emp(i_empno VARCHAR2) IS
2 v_sql VARCHAR2(2000);
3 v_ename VARCHAR2(40);
4 BEGIN
5 v_sql := 'select ename from emp where empno=:empno';
6 EXECUTE IMMEDIATE v_sql
7 INTO v_ename
8 USING i_empno;
9 dbms_output.put_line(v_ename);
10 END;
11 /
Procedure created
SQL> exec query_emp('7369');
SMITH
PL/SQL procedure successfully completed
SQL>