I am using forms 10g.
I have a tabbed canvas and in that i have one location field.
In that location fileld i have created a stacj canvas which is based on No table.
In that location block I have 4 fields lke Room, Block, Dept and floor. All the fields i have attached one one LOV. When u choose all the field s and then click ok then it will generate a code base don that infirmation and save in that location filed in the tabbed canvas.
But when i am double click or Press enter it is going to that stack canvas but Showing this error : ORA-01403 : No data found-100
After i can able to save that , no problem .
But what is that error ?
Edited by: Sandip Mohapatra on Feb 6, 2010 4:36 AM
Is there any select into statements in your code? If yes, then check those statements and as Zahid specified, if there is a chance of no data returning, then you have to use EXCEPTION handler, or have to use cursor.
Thank you very much.
Actually i have a stack canvas in location field .
So i i try to open that stack canvas the when validate record trigger is firing .
That time i have select statement in that location field..