Silly bindvar trouble in a dynamic plsql block within package.

From: Frank Zaum <frankzaum_at_yahoo.de>
Date: 17 Apr 2002 08:37:49 -0700
Message-ID: <4c1e5bbe.0204170737.425fcd74@posting.google.com>

I have some trouble with this dynamic plsql block inside a nested cursor loop in a package
...

for cursor1 in ...
  for cursor2 in ...
  v_stmt := 'BEGIN DBMS_SPACE.UNUSED_SPACE(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10);';

  execute immediate v_stmt using v_owner, v_cur_tab, v_segment_type,   v_total_blocks, v_total_bytes, v_unused_blocks, v_unused_bytes, v_last_used_efid, v_last_used_ebid, v_last_used_block;                  

	insert into hist_stats values (
	'dumb',
	v_timestamp,
	v_total_blocks,
	v_total_bytes,
	v_unused_blocks,
	v_unused_bytes,
	v_last_used_efid,
	v_last_used_ebid,
	v_last_used_block

   end loop;
end loop2;
...

the hole thing is compiled w/o error, but when i take a look at the table, its still empty. i have no idea whats going on. any help would be appreciated. Received on Wed Apr 17 2002 - 10:37:49 CDT