求助```为什么我执行下面的过程老是报错
CREATE OR REPLACE PROCEDURE test_procedure
as
eid newbooks.author1%type;
sa varchar2(100);
begin
sa := 'SELECT author1 into '|| eid || ' FROM newbooks where isbn= ' '72222492 ' ' ';
execute immediate sa;
DBMS_OUTPUT.PUT_LINE(eid);
end;
/
SQL> EXEC test_procedure
错误为:
第一行出现错误;
ORA-00936:缺式表达式
ORA-06512:在 "SYSTEM.TEST_PROCEDUDURE ",line 8
ORA-06512:在line1
------解决方案--------------------
动态sql不要用select into结构。