Declare
Variables in the package method
begin
assign the values to the IN PARAM
Call Package method by passing the paramaters
end;
example:
DECLAREi_account_update_reason_id ACCOUNT_UPDATE_REASON.account_update_reason_id%TYPE;o_account_update_reason_row ACCOUNT_UPDATE_REASON%ROWTYPE;BEGINi_account_update_reason_id:= 28;GUI_DATABASE_ACCESS. load_account_update_reason(i_account_update_reason_id,o_account_update_reason_row );END;
No comments:
Post a Comment