Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SP2-0552: Bind variable not declared error. Any help please?

632909Nov 13 2008 — edited Nov 13 2008
Hi Experts,

I have a question regarding the error that I am getting: SP2-0552: Bind variable "V_COUNT_TOT_BAL" not declared.

I have 'out' parameters declared in my procedure and executing the same from sql script as shown below:

--------------------------------------------------------------------------------------------------------------------------------------------------------
set ver off
set serverout on
set linesize 8000

Declare
Variable v_count_dtl_bal NUMBER(10);
Variable v_updat_dtl_bal NUMBER(10);
Variable v_count_tot_bal NUMBER(10);
Begin
execute load_abc.insert_abc_bal(:v_count_dtl_bal,:v_updat_dtl_bal,:v_count_tot_bal);
End;
/
exit;
--------------------------------------------------------------------------------------------------------------------------------------------------------

So, when this sql script runs it given me the above error. However, all the result looks good and there's no problem with the data or anything else that might be impacted. I suspect this error stems from the code in the sql script above.

Any idea what am I doing wrong?
Thanks in advance for any inputs.
This post has been answered by Frank Kulash on Nov 13 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2008
Added on Nov 13 2008
8 comments
14,331 views