Hi,
Is it possible to rollback a package which have been created? If not how to rollback changes made by package using ROLLBACK; statement?
create or replace
package pckg as
procedure prc(column in number);
end;
--ROLLBACK??
create or replace
package pckg as
procedure prc (column in number) as
begin
insert into smth(column1)
SELECT column1 FROM somewhere;
end prc;
end emp_pac;
--ROLLBACK??
DECLARE
column1 NUMBER;
BEGIN
SAVEPOINT savepnt;
column1 := NULL;
pckg.prc(column1 => column1);
END;
--ROLLBACK TO SAVE POINT savepnt??