Home » SQL & PL/SQL » SQL & PL/SQL » Package verification (10.2.0.3.0)
Package verification [message #403134] Wed, 13 May 2009 22:15 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

Please carry out the technical review for the package attached. Technical review can include following aspects of the code:
- Syntax
- Cursor usage (opening/closing cursors)
- Performance improvement
- Optimizing the code etc

Please add your commnets for the above aspects.

Thank you,
  • Attachment: Pack1.txt
    (Size: 202.71KB, Downloaded 492 times)

[Updated on: Wed, 13 May 2009 22:20]

Report message to a moderator

Re: Package verification [message #403136 is a reply to message #403134] Wed, 13 May 2009 22:20 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
user71408 wrote on Wed, 13 May 2009 20:15

Please carry out the technical review for the package attached.


No, thank you.
I decline to do your job for you.
Re: Package verification [message #403151 is a reply to message #403136] Wed, 13 May 2009 23:52 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Swan,

Please have a look into the Package and let me know your suggestions/modifications.

Thank you
Re: Package verification [message #403154 is a reply to message #403134] Thu, 14 May 2009 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
No, thank you.
I decline to do your job for you.

Exactly WHAT is your contribution to YOUR job requirements?

[Updated on: Thu, 14 May 2009 00:02]

Report message to a moderator

Re: Package verification [message #403156 is a reply to message #403154] Thu, 14 May 2009 00:05 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

It's not my job requirement. I have written this package. But for execution it's taking much time. So i need your suggestions if any modifications required.

Thank you
Re: Package verification [message #403158 is a reply to message #403134] Thu, 14 May 2009 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>It's not my job requirement.
Let those who have the requirement resolve it.
Re: Package verification [message #403161 is a reply to message #403158] Thu, 14 May 2009 00:14 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

After writing the package it's my job for checking the Package is executing perfectly or not ? am I right? That's why am requesting your suggestions.
Re: Package verification [message #403162 is a reply to message #403134] Thu, 14 May 2009 00:19 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

There are hell lot of procedures in the package, exactly what is your requirement ??

I am really curious that you just send everything to the forum and expect the people here to do it for you,

Post whatever you have tried, and clearly mention what is your requirment, dont simply write it in High Level
Re: Package verification [message #403178 is a reply to message #403134] Thu, 14 May 2009 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As OP asked to delete this topic, it is locked.

Regards
Michel
Re: Package verification [message #403252 is a reply to message #403161] Thu, 14 May 2009 08:01 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
user71408 wrote on Thu, 14 May 2009 01:14
After writing the package it's my job for checking the Package is executing perfectly or not ?



Yes, it is YOUR job, so do it or go into a new line of work.
Previous Topic: Remove Special chracters and Carriage
Next Topic: Comparing two fields in the same table to see if they are different
Goto Forum:
  


Current Time: Sun Dec 04 14:31:57 CST 2016

Total time taken to generate the page: 0.05378 seconds