PL/SQL (MOSC)

MOSC Banner

How to execute a procedure?

edited May 4, 2016 3:08PM in PL/SQL (MOSC) 9 commentsAnswered ✓

Hi,

i want to execute below procedure ..

create or replace

PROCEDURE distr_booking_performance

(p_sls_code IN bks_sales_str.sls_code%TYPE,

  p_period IN bookings_activity_actual.period%TYPE,

  p_rpt_type varchar default 'S',

  p_cursor IN OUT booking_performance_pkg.book_perf_type)  (Note # booking_performance_pkg.book_perf_type  -->it is a ref cursor type)

---

some code

---

END distr_booking_performance;


Is it any thing wrong here executing this ?

-----

declare

v booking_performance_pkg.book_perf_type;

begin

distr_booking_performance('xx','yy',v)

end;

-----


Thanks,

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