Regarding rollback statement.....

Database
Enthusiast

Regarding rollback statement.....

hi all,

can anyone tell me the functionality of rollback in this statement?........

replace macro ops_dbs.del_nei_ric (
ric varchar(17)
)
as (
rollback 'Temp Ric does not exists ' where :ric not in
(
select ric
from adb_prod_t.traded_item_on_market
where ric = :ric
and ti_on_market_id > 100000000
);
);

regards,
dinesh
2 REPLIES
Enthusiast

Re: Regarding rollback statement.....

if the select query does not return a record for the value of ric given as argument to the macro, the current transaction would be aborted (any changes done as part of the transaction would be reverted back to their original state). And the message 'Temp Ric does not exists ' would be generated.
Enthusiast

Re: Regarding rollback statement.....

thanx for reply.....

i want to know one more thing...how we can implement above rollback statement in oracle.....

Regards,
Dinesh