this is solved.
Main Topics
Browse All TopicsI have the trouble with the stored procedure returning ref cursor.
I used the code provided by Horst.
I have the same problem HELP!!!
I keep coming up with the same problem and cannot figure it out, any help would be appreciated.
--------------------------
[WebMethod(Description = "Compare PriceList")]
publicDataSet ComparePriceListDelete(str
{
string procedureName = "init_price.PRICE_LIST_REP
System.Data.DataSet DSNew = newDataSet();
Database db = DatabaseFactory.CreateData
DbCommand dbCommand = db.GetStoredProcCommand(pr
db.AddInParameter(dbComman
db.AddInParameter(dbComman
db.AddOutParameter(dbComma
db.AddOutParameter(dbComma
DSNew = db.ExecuteDataSet(dbComman
Status = dbCommand.Parameters[2].Va
return (DSNew);
}
It returns invalid column 7.
here is my stored proc.
PROCEDURE price_list_deletions (cur_out IN OUT t_cursor,
p_old_price_list_id IN price_list_dtl.price_list_
p_new_price_list_id IN price_list_dtl.price_list_
p_status OUT NOCOPY varchar2)
IS
rec_count number := 0;
BEGIN
p_status := 'Success';
SELECT count(*) into rec_count
FROM (
SELECT grade_code_dtl_id
FROM price_list_dtl
WHERE price_list_hdr_id = p_old_price_list_id
MINUS
SELECT grade_code_dtl_id
FROM price_list_dtl
WHERE price_list_hdr_id = p_new_price_list_id);
If rec_count = 0 then
p_status := 'No Data';
OPEN cur_out
FOR
SELECT count(*)
FROM price_list_dtl
WHERE price_list_hdr_id = p_old_price_list_id
MINUS
SELECT count(*)
FROM price_list_dtl
WHERE price_list_hdr_id = p_new_price_list_id;
else
OPEN cur_out
FOR
SELECT grade_code_dtl_id
FROM price_list_dtl
WHERE price_list_hdr_id = p_old_price_list_id
MINUS
SELECT grade_code_dtl_id
FROM price_list_dtl
WHERE price_list_hdr_id = p_new_price_list_id;
end if;
EXCEPTION
WHEN others THEN
p_status := 'Failure: ' || SQLERRM;
END price_list_deletions;
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: MikeOM_DBAPosted on 2008-06-24 at 11:42:36ID: 21858927
What is the COMPLETE error message?