求助```为什么我执行下面的过程老是报错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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货