Skip to Main Content
Forums

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!

error: bind variable not found

563299Mar 28 2007 — edited Mar 28 2007
hi all,

this is my code
declare
variable total_blocks number;
begin
execute DBMS_SPACE.UNUSED_SPACE('xmluser','CUSTOMER','TABLE',:total_blocks);
print total_blocks;
end;

error while compiling:

SQL> @sp1.sql
8 /
SP2-0552: Bind variable "TOTAL_BLOCKS" not declared.

please help me to sort out this problem.

thanks in advance
karthik.J
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2007
Added on Mar 28 2007
17 comments
1,392 views