Mike Mascari wrote: > 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
OK, two requests. First, would you create a _named_ PL/SQL function with those contents and try it again. Also, would you test CURRENT_TIMESTAMP too? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
