create or replace package lcp_archive
as
procedure lcp_archive_proc (check_id_var in number, status_var out varchar(1));
end lcp_archive;
create or replace package body lcp_archive
as
...
Type: Posts; User: shashijsr
Stored proc to fetch row from 1 table and insert into another and delete from the 1st
create or replace package lcp_archive
as
procedure lcp_archive_proc (check_id_var in number, status_var out varchar(1));
end lcp_archive;
create or replace package body lcp_archive
as
...