CREATE OR REPLACE PROCEDUREdt_query(
username IN VARCHAR2
)
IS
mycompany VARCHAR2(200);
TYPE refcursor IS REF CURSOR;
c1 refcursor;
BEGIN
OPEN c1 FOR 'SELECT company FROM personnel WHEREpersonnel_ename = :x' USING inusername;
LOOP
FETCH c1 INTO mycompany;
IF c1%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE('NO DATA FOUND');
EXIT;
END IF;
dbms_output.put_line(mycompany);
END LOOP;
CLOSE c1;
END dt_query;
exec dt_query('zhouyong')
显示‘NO DATA FOUND'
但
SQL> SELECT company FROM personnel WHERE personnel_ename = 'zhouyong';
COMPANY
--------------------------------------------------------------------------------
海南股份有限公司宁波分中心
为什么，请大家帮帮忙
create table PERSONNEL
(
PERSONNEL_ENAME CHAR(20) not null,
PERSONNEL_CNAME CHAR(30),
MEMO
CHAR(50),
ORDERNUMFLOAT not null,
KINDS FLOAT not null,
OTHER_KINDS FLOAT,
TRACE_KINDS FLOAT,
COMPANY CHAR(100),
COMPANY_CODECHAR(6)
) |
