i am writting stored procedure with one one cursor parameter which is of out direction.

procedure getAssetCategory(p_cursor out Cursor_Type.cursor_type )
as
begin
      open p_cursor for select distinct asset_category, asset_category_desc from asset_category;
end getAssetCategory;

i want to calling this stored procedure in my application...

can anybody help me how to write code for this.

thanks,
Kosaraju

Refer this

http://support.microsoft.com/default...b;EN-US;310101


It is not how much we do,
but how much love we put in the doing.

-Mother Theresa