Re: Dynamic sql problem on 9iR2

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 27 Oct 2004 23:09:13 +0200
Message-ID: <md30o0hhgq50tem831eurggd8c6ssf9eft@4ax.com>

On 27 Oct 2004 07:14:14 -0700, kamal80_at_virgilio.it (Kamal) wrote:

>I think this is a bug or something like that, what is your opinion?

my opinion is

- your coding style is more than horrible, and your code unreadable.
- every procedure should have an exception handler
- you should check out the current_user and session_user

to verify you are actually in the proper user context and are addressing the proper objects in this myriad of ill-choosen object names.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Oct 27 2004 - 16:09:13 CDT