how to solve ORA-03114 [message #502813] |
Sun, 10 April 2011 03:17 |
kalpataru
Messages: 72 Registered: January 2010 Location: INDIA
|
Member |
|
|
hi all,
i am really astonished why this error is coming in this particular form.
i have developed two forms
first i have developed a web_util related function form in that form i am using this code
below in when-button-pressed
DECLARE
rowcol varchar(20);
cursor mm is
select ENAME from SCOTT.emp; ---------------but from this line it is showing error ORA-03114
BEGIN
for i in mm loop
exit when mm%notfound;
rowcol := i.ENAME;
end loop;
END;
then after getting this error i have developed another form for testing that error
in when-button-pressed i have written this code
DECLARE
CURSOR MM IS
SELECT ENAME FROM EMP;
BEGIN
GO_BLOCK('EMPGRID_BLK');
CLEAR_BLOCK(NO_VALIDATE);
LAST_RECORD();
FOR REC IN MM LOOP
EXIT WHEN MM%NOTFOUND;
:EMPGRID_BLK.TEXT_ENAME := REC.ENAME;
CREATE_RECORD();
END LOOP;
FIRST_RECORD();
END;
it is working fine.
please help me why that error is coming in the first form actually where is the problem
my forms version is := Forms [32 Bit] Version 10.1.2.0.2 (Production)
database version is := Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
os is windows xp sp2
any help is deeply appreciated please give proper/pin point solution.
i very hopeless by search in this error in net not getting any solution yet.
please reply...
|
|
|
|
|
|
|
Re: how to solve ORA-03114 [message #502908 is a reply to message #502851] |
Mon, 11 April 2011 08:36 |
kalpataru
Messages: 72 Registered: January 2010 Location: INDIA
|
Member |
|
|
hi ranamirfan,
i have already tested by writing
Select ENAME from SCOTT.emp;
not successful same error
and for adeelali i have not used any 'PRE-FORM' or 'PRE-QUERY'
in the block level..
|
|
|
|
Re: how to solve ORA-03114 [message #503043 is a reply to message #502957] |
Tue, 12 April 2011 09:02 |
kalpataru
Messages: 72 Registered: January 2010 Location: INDIA
|
Member |
|
|
hi Littlefoot,
i have written web_util related function form
why because in that form(which shows the error ORA-03114)
i have done the webutil function means i have created successfully the webutil related programs and webutil related programs running successfully.
but in the general form which have no related functions in that form the error is not there..
so i want solution of that error..
|
|
|