I need to make this:

execute get_number('P', 2006)

Insert into table ( ) values( )

if and only if Inserted values in table {

execute set_number('P', 2006)

}
else
exception ....


How can I do this. note this is storeprocedure-like


Thank's a lot

Bye
Alberto

[Non-text portions of this message have been removed]