Re: help on a generic get_nextval function?

From: Jared <jared_at_hwai.com>
Date: 22 Jul 2004 06:21:08 -0700
Message-ID: <480f610.0407220521.48a49f2f@posting.google.com>

Yes, I got it working last night using DBMS_SQL and SQL trace was pretty clear on my choice of elegance over efficiency. Back to the efficient, labor-intensive approach for me.

Thanks for responding!

Kind regards,
jh

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<g6ntf0l4rlo9f98d5fml8vvmmbtsc9djm7_at_4ax.com>...
> On 21 Jul 2004 13:36:58 -0700, jared_at_hwai.com (Jared) wrote:
>
> >Am I going to have to construct a string using DBMS_SQL? I was hoping
> >there was an easier way.
>
> You have a variable sql statement. You are using static sql.
> Consequently this is not going to work and you need dbms_sql or better
> execute immediate (8i and higher)
>
> However, you'll now will incur a hard or soft parse for every
> invocation of the function. You are trying to save a few keystrokes by
> introducing a sledgehammer in your application.
Received on Thu Jul 22 2004 - 08:21:08 CDT