2 short questions (DBMS_SQL)

1. When should one use BIND_VARIABLE instead of string concatenation? E.g.: v_Stuff := 'SELECT :m FROM table'; vs. v_Stuff := 'SELECT ' || stuff || ' FROM table';
2. When I try to drop a procedure absolutely nothing happens. SQL*PLUS just 'freezes' and stays there until I get the following timeout

  SQL> drop procedure mapdocument;
  drop procedure mapdocument

  ERROR at line 1:
  ORA-04021: timeout occurred while waiting to lock object   BIIS.MAPDOCUMENT   Can any of you help me decipher this?

Thanks a ton

Morten Received on Mon Jul 05 1999 - 03:17:45 CDT