SQL>SET serveroutput ON
SQL>CREATE OR REPLACE PROCEDURE test(jbh in varchar2) AS
BEGIN
DECLARE
r_count number(10);
BEGIN
select count(*) INTO r_count from jjxxx where ssjz like '%'||jbh||'%';
dbms_output.put_line(r_count);
END;
END test;
SQL>CREATE OR REPLACE PROCEDURE test(jbh in varchar2) AS
BEGIN
DECLARE
r_count number(10);
BEGIN
select count(*) INTO r_count from jjxxx where ssjz like '%'||jbh||'%';
dbms_output.put_line(r_count);
END;
END test;
就可以了.测试:
SQL>exec test('aaa');... Good luck ...