Re: help on a generic get_nextval function?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 21 Jul 2004 23:17:02 +0200
Message-ID: <g6ntf0l4rlo9f98d5fml8vvmmbtsc9djm7@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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jul 21 2004 - 16:17:02 CDT