PL/SQL beginner problem

From: Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com>
Date: 2000/05/11
Message-ID: <8ff7nk$u37$1@nnrp1.deja.com>#1/1

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. Received on Thu May 11 2000 - 00:00:00 CDT