Oracle Forms

I have a stored procedure (function, actually) that allows an administrator to manually delete a record from a table.

When I call it from my form it will not have an effect. The record remains in the table.

In both cases I am connecting to the database as the same user.

I am able to call a test function in the database that returns a field from the record, so I know that I can at least connect with and retrieve results from the database using a stored function. As soon as I turn the "select from" to "delete from", no luck.

If I try to run the SQL in my form using a FORMS_DDL statement, it appears to execute without problem when I step through the code in the debugger but there is no effect taken. FORMS_SUCCESS reports TRUE though DBMS_ERROR_TEXT has the following: ORA-01403: no data found. I am not sure how relevant DBMS_ERROR_TEXT is given that FORMS_SUCCESS does not have a value of FALSE.

Any ideas as to why I am unable to delete using my form but can when calling the stored function directly/manually?

Using Oracle Forms & DB 10.0.2.0.1.