ORA-0000: Normal, successful completion ??
JCAug 7 2009 — edited Oct 4 2011Hi
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