Bruce Momjian wrote:
> Mike Mascari wrote:
>>
>>Oracle isn't processing those statements interactively. SQL*Plus
>>is waiting on the "/" to send the PL/SQL block to the database.
>>I suspect its not going to take Oracle more than a second to
>>insert a row...
>
>
> Oh, I understand now. He delayed when entering the function body, but
> that has no effect when he sends it. Can someone add an explicit sleep
> in the function body and try that?
>
SQL> create table foo (a date);
Table created.
SQL> begin
2 insert into foo select sysdate from dual;
3 dbms_lock.sleep(5);
4 insert into foo select sysdate from dual;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> select to_char(a, 'HH24:MI:SS') from foo;
TO_CHAR(
--------
11:31:02
11:31:07
Mike Mascari
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
