Re: Dynamic SQL or Stored procedure?

From: tina london <tinalondon_at_demon.co.uk>
Date: Tue, 19 Jul 2005 13:49:30 +0100
Message-ID: <dbj213$mt4$1$8300dec7@news.demon.co.uk>

"Ach C via DBMonster.com" <forum_at_DBMonster.com> wrote in message news:518C5FB3EA77F_at_DBMonster.com...
>
> Hi,
> I have many stored procedures written by another person that performs
only
> ONE select statement using an input parameter.
> Do you think it is better to implement them as dynamic sql in application
> source rather than calling them using stored procedures? I concern
> performance issues.
> -Thanks in advance
>
>
> --
> Message posted via DBMonster.com
> http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200507/1

If they work correctly and in an efficient manner. Just leave them alone, unless you haven't a lot of work on at the moment.

regards

Tina London Received on Tue Jul 19 2005 - 07:49:30 CDT