Home » SQL & PL/SQL » SQL & PL/SQL » Need Help for better Performance of the Package
Need Help for better Performance of the Package [message #416173] Fri, 31 July 2009 00:06
Messages: 56
Registered: April 2009

I have written a Package for my project requirement where it has to return the result/record set as o/p and the front end application is DOT NET.<<Attached is for your reference>>

But when the user is trying to pass all the NULL values as input params (as you can see in my package)...it has to retrive only latest 100 records...but it is taking more than one min to get the window to display the 100 records...

I have written similar packages for the rest of the screens.So please help me regarding the peroforamce of the code.

Please let me know if the written code can be modifed or re-written in a better way to increase the performance.

Any help is appreciated.


  • Attachment: Header.sql
    (Size: 37.37KB, Downloaded 292 times)

[Updated on: Fri, 31 July 2009 00:09]

Report message to a moderator

Previous Topic: ORA-06502: PL/SQL: numeric or value error while using CLOB
Next Topic: update required
Goto Forum:

Current Time: Sun Oct 23 18:55:41 CDT 2016

Total time taken to generate the page: 0.07449 seconds