Re: PL/SQL beginner problem

Try removing the : from the assignment, I think you'll find that it will work after that.

In article <8ff7nk$u37$1_at_nnrp1.deja.com>, Ed.Stevens_at_nmm.nissan-usa.com says...
> 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.
>
 

-- 
Regards,


William.
 
EuroNet*Internet BV, http://www.euronet.nl/
Wm. G. Urquhart, Oracle DBA
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam
T:+31 20 5355263, F:+31 20 5355400, E: williamu_at_nl.euro.net
M:+31 06 28206038 ICQ: 56047340