Oracle Forms

HI

I am designing a basic application with the standars procedures of inserting, deleting, modifying and consulting on forms 6i and oracle 9i.
The issue is that if i insert data using the insert command through forms, then i am able to retrieve it (using forms and sql) but if i insert data using the insert command through SQL, then i cannot retrive the data on forms. It activates the exception when no data found, but if i do a select using SQL, the data is there in the database(table).

Can someone tell me what i may be doing wrong or what may be happening?

Thanks in advanced