Re: 2 short questions (DBMS_SQL)

1. Bind variables are more efficient.
2. Cant help you on the other one. Maybe someone is holding a lock on the table you want to drop?

M

Morten wrote in message ...
>
>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 - 04:25:48 CDT