如何在Oracle Form Developer中运行未运行的Ddl语句，但在Plsql中工作 [英] How Can I Run A Ddl Statement That Is Not Running In Oracle Form Developer But Working In 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屋！