Executing Procedure From APEX
NirvanaNov 2 2012 — edited Nov 3 2012Hi Gurus,
I have created a paramterized procedure: ( SQL Worskshop-> Object Browser -> Create-> Procedure)
create or replace procedure "PRC_INV_DELETE"
(param1 IN NUMBER,
param2 IN NUMBER)
is
begin
DELETE FROM INVOICE where INV_NUMBER IN ( param1, param2);
end;
Can any one please tell how to execute this simple procedure with parameters from APEX,
Thanks in advance