Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Test Result set procedure with cursor

676712Dec 21 2008 — edited Dec 23 2008

i am really new for oracle and i don't know how to test my result set procedure in oracle.
i am now working on Oracle 10g Express Edition.

my procedure is below.

create or replace procedure "GETORDERSBYCATALOGUECODE"
(p_cataloguecode IN VARCHAR2, p_cursor IN OUT SYS_REFCURSOR )
is
begin
open p_cursor for SELECT OrderID, NumberOrdered, CostCharged
FROM OrderDetails
WHERE CatalogueCode=p_cataloguecode;
end;

i am not sure how can i work with the the cursor and the procedure to display cursor data in Oracle 10g Express Web Admin?

Tunk

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2009

Added on Dec 21 2008

2 comments

499 views