Hi friends,
i developed one complex query with parameters that satisfy my business requirments.
Now, i want to convert this query with parameter into Oracle 10 G Procedure.
i want to use this Procedure's result sets into Crystal Reprots.
i did googling, most of people suggesting, to declare Cursor inside Procedure and then use this Cursor
inside Oracle Package.
But, i fundamentally not understand why to use Cursor in Procedure and Package ?
any kind of suggestion is well come.
Thanks.
Happy New Year to all.
Thanks.
i developed one complex query with parameters that satisfy my business requirments.
Now, i want to convert this query with parameter into Oracle 10 G Procedure.
i want to use this Procedure's result sets into Crystal Reprots.
i did googling, most of people suggesting, to declare Cursor inside Procedure and then use this Cursor
inside Oracle Package.
But, i fundamentally not understand why to use Cursor in Procedure and Package ?
any kind of suggestion is well come.
Thanks.
Happy New Year to all.
Thanks.