Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-0000: Normal, successful completion ??

JCAug 7 2009 — edited Oct 4 2011
Hi
I have the below code to be executed on the click of delete image in the tabular form rows in the form.

DECLARE
v_query VARCHAR2(200);

BEGIN
DELETE FROM tab1
WHERE
col1 = :t1
AND col2 = :t2
AND col3 = :GLOBAL.glb_code
AND col4 = :PARAMETER.Pxxxxx ;

FORMS_DDL('COMMIT');

v_query := ' coll1 =''' || :GLOBAL.glb_code || '''' ;
v_query := v_query || ' coll2 = ''' || :PARAMETER.Pxxxxx || '''' ;

SET_BLOCK_PROPERTY('BLK_CONTABILITA', DEFAULT_WHERE, v_query);
GO_BLOCK('BLK_CONTABILITA');
message('1');
EXECUTE_QUERY;
message('2');

EXCEPTION
WHEN OTHERS THEN
MESSAGE('Error :' || SQLCODE || '-' ||SQLERRM) ;
END ;

The code is successfully able to delete the record for a specific condition I am passing, and it the same time the form has to be refreshed by doing the execute query.

I checked with giving the messages after every line above. I am getting the message 1, and then getting SQLERRM as ORA-0000: Normal, successful completion ...AND SQLCODE as 0 ...and then getting message 2

Does anyone have any idea on this similar situation.

Regards
JC
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2011
Added on Aug 7 2009
5 comments
31,717 views