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
ramesh
NA
19
46.8k
Procedure created with compilation errors.
Aug 13 2012 5:57 AM
CREATE OR REPLACE
PROCEDURE get_state (p_state IN sample_country_info.state_name%TYPE,
p_recordset OUT SYS_REFCURSOR) is
BEGIN
OPEN p_recordset FOR
SELECT country_id,
country_name,
FROM sample_country_info
WHERE state_name = p_state;
* end get_state;
when i run this program it shows procedure created with complilation error...
where is the error please help me?
Reply
Answers (
1
)
invalid cursor... please correct my query
write a stored procedure for following eg::