Re: quick pl/sql question

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Thu, 08 Oct 2015 11:50:53 -0600
Message-ID: <5616ACFD.2070309_at_gmail.com>

Hmmm ... ":1" implies it a positional bind variable.

What is the hosting environment? SQLPlus? Toad? Java?

/Hans

On 08/10/2015 11:08 AM, Sweetser, Joe wrote:
> SQL_Stmt := 'DELETE FROM renewal_expacc_data WHERE policy_num = :1';
> EXECUTE IMMEDIATE SQL_Stmt USING stage_data_rec.policy_num;

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 08 2015 - 19:50:53 CEST