Re: Dynamic sql problem on 9iR2

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<md30o0hhgq50tem831eurggd8c6ssf9eft_at_4ax.com>...

> - your coding style is more than horrible, and your code unreadable.

Sure. Thank you for your opinion.
I think "code" is a big word for this:

create package body p00 as
procedure tt (tn in char)
is
begin
execute immediate ('truncate table ' || tn); end tt;
end p00;
/

I call it an example.

> - every procedure should have an exception handler

This is just a example to show errors so I don't have to manage errors that I want to show.

> - 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.

Once again: this is only a simplified example of other code. Do you prefer package "TrTableFooBarCustCodeDifficultMathematicalExpression"? Or is it better "p00"?

What should I verify? I just connect with that user and that's it. I don't use application contexts or similar.

Did you try the script? Have you verified it works on your machine before speaking?
It seems you prefer to judge people instead of helping them.

Kamal Received on Fri Oct 29 2004 - 06:33:48 CDT