How to execute a procedure?
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,