how to excecute a simple oracle procedure with out parameter

I am new to oracle procedures so I'm having a bit of trouble with this. I have an oracle procedure defined like

PROCEDURE USERPROGRESS (
queryType IN varchar2,
o_Cursor OUT cur开发者_开发知识库_Cursor) IS ...

Notice how it has the out cur_Cursor. At the end of the procedure the procedure does

OPEN o_Cursor FOR sql_string;

How exactly do I can I call this procedure? I'm having trouble finding any helpful examples. Thanks.

Check this link..

http://www.oracle-base.com/articles/misc/UsingRefCursorsToReturnRecordsets.php

Depending on how you declared cur_Cursor, you can define a variable in your procedure and then fetch and display the results as needed.