Re: performance tuning of stored procedure

KK wrote:
> couldn't get exaclty how to change. can anybody please modify my stored
> proc code accordingly??
>
> Thanks

What are you offering per hour to do your job? ;-)

Will work for a decent single-malt.
Will advise for a Chimay.

Seriously ... just take the code from the library and modify it. If you don't know how to do that see your manager about getting the training you need to do your job.

-- 
Puget Sound Oracle Users Group