Re: PL/SQL beginner problem

get rid of the : before the variable name

In article <8ff7nk$u37$1_at_nnrp1.deja.com>,   Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:
> The following is pretty self-explanatory. Question is: why am I
> getting the error "Bind variable "V_LAST_FAILURE_SZ" not declared"?
> Looks declared to me.
>
> SQL> declare
> 2 v_shrd_pool_rsrvd_sz v$parameter.value%TYPE :=0;
> 3 -- snip several other variables like this
> 4
> 5 procedure get_parms is
> 6 begin
> 7 -- snip procedure code
> 8
> 9 end get_parms;
> 10
> 11 procedure chk1 is
> 12 v_last_failure_sz number;
> 13 begin
> 14
> 15 select sum(last_failure_size)
> 16 into :v_last_failure_sz
> 17 from v$shared_pool_reserved;
> 18
> 19 end chk1;
> 20
> 21 begin
> 22
> 23 get_parms;
> 24 chk1;
> 25
> 26 end;
> 27 /
> Bind variable "V_LAST_FAILURE_SZ" not declared.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 11 2000 - 00:00:00 CDT