RE: Interesting PL/SQL Puzzle

You have not provided me with anything (I cannot post these things to public forums because of my email)!

The only thing you said bad code, good code!

I was not impressed the way the code works, this is why I had to research issue until I found the problem using "LIKE".

Of course it was easy for anybody to figure it out from here.

The idea is to add value instead of waiting to have the final words!

Regards,

Waleed

-----Original Message-----
Sent: Monday, November 10, 2003 11:34 PM To: Multiple recipients of list ORACLE-L

Khedr, Waleed wrote:
> The question was not if it's a good or bad code. The question was why?
> This is not the actual code that runs, just something that explains the
> issue :)

I've provided a selfexplanatory fix of the 'bad' code, please review it. You code uses standard.like, and a lot "isntances of booleans" -- each IF condition, same could relate to out variables (ls), and I hope you understood why the package is used.

"I would suggest to consider some simple things:

. standard Oracle and your application's package(s) dependencies . proper datatypes usage
"

I cannot provide you with tech. details open the C (native) code and see.

-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Begun
  INET: vladimir.begun_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).