TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Pramod Shivhare
NA
7
13.7k
Procedure inside procedure
Jan 26 2012 8:43 AM
i have following structure of a procedures inside a package:
PROCEDURE proc_All
(
start IN date := null,
end IN date := null,
cursor1 OUT sys_refcursor,
cursor1 OUT sys_refcursor,
cursor1 OUT sys_refcursor );
PROCEDURE proc_1
(
start1 IN date := null,
end1 IN date := null,
cursor1_1 OUT sys_refcursor, );
PROCEDURE proc_3
(
start2 IN date := null,
end2 IN date := null,
cursor1_2 OUT sys_refcursor, );
PROCEDURE proc_3
( start3 IN date := null,
end3 IN date := null,
cursor1_3 OUT sys_refcursor, );
Now my requirement is that i want first procedure proc_All to call all three next procedure, as i want proc_All to be called by program. how can i pass variables to a procedure when calling inside other procedure (weather they are IN or OUT type)
can anyone please help.. thanx in advance
Reply
Answers (
1
)
Organizing Tablespaces
select rows from selected rows.