PL/SQL (MOSC)

MOSC Banner

sysrefcorsor error handling

edited Sep 25, 2012 10:40PM in PL/SQL (MOSC) 1 commentAnswered
CREATE OR REPLACE package fp_error as

TYPE t_cursor IS REF CURSOR;
procedure pr_fig(
p_mkt_sec                 in    varchar2    default null,
p_mkt_sub_sec             in    varchar2    default null,
p_comm_group              in    varchar2    default null,
p_comm                    in    varchar2    default null,
p_sub_comm                in    varchar2    default null,
p_time                    in    varchar2    default null,
io_cursor                 out   t_cursor,
p_out                     out   number
);

end fp_error;
/

CREATE OR REPLACE package body fp_error as
procedure pr_fig(
p_mkt_sec                 in    varchar2    default null,
p_mkt_sub_sec             in    varchar2    default null,
p_comm_group              in    varchar2    default null,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center