Re: Bind variable error

Are you sure the error is here ?

Is it possible that further down in the block (line 33) you use v_group_id and have a colon ':' in front of it, which would make it a bind variable when it has already been declared as a local PL/SQL variable ?

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jason Edleman wrote in message <924722212.734.17_at_news.remarQ.com>...
>Hi all,
>
>I am compiling a SP and during compilation I receive a
>
>33/11 PLS-00049: bad bind variable 'V_GROUP_ID'
>
>here is what it looks like:
>
>DECLARE
>v_group_id member_eligibilities.group_id%type;
>
>All rights to the table are granted.
>Even if I remove the reference to this table and say . .
>
>v_group_id char(15);
>
>I still get the message.
>
Received on Wed Apr 21 1999 - 14:37:03 CDT