如何在Oracle Form Developer中运行未运行的Ddl语句,但在Plsql中工作 [英] How Can I Run A Ddl Statement That Is Not Running In Oracle Form Developer But Working In Plsql
本文介绍了如何在Oracle Form Developer中运行未运行的Ddl语句,但在Plsql中工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
declare
meritz merit%rowtype;
cursor cursor_a is
select * into zish.meritz
from zish.merit
where ROWNUM <=30;
Begin
open cursor_a;
fetch cursor_a into meritz;
insert into zish.merit_list_detail(applicant_id,marks_obtained)
values( meritz.applicant_id, meritz.grand);
close cursor_a;
end;
i我在触发器中使用此代码按下按钮时我得到的错误信息
错误:103遇到符号进入
i am using this code in a trigger of when button pressed i got am error message
error:103 encountered the symbol into
推荐答案
脚本中存在语法错误。你的脚本真的编译了吗?检查以下
There are syntax error in your script. Is your script really compile? Check below
declare
meritz merit%rowtype;
cursor cursor_a is
select * into meritz
from zish.merit
where ROWNUM <=30;
Begin
open cursor_a;
fetch cursor_a into meritz;
insert into zish.merit_list_detail(applicant_id,marks_obtained)
values( meritz.applicant_id, meritz.grand);
close cursor_a;
end;
这篇关于如何在Oracle Form Developer中运行未运行的Ddl语句,但在Plsql中工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文