| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: For You Sticky Developers out there.....
<FONT face=Arial color=#0000ff
size=2>Thanks, Jimmy.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>:-)
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Jacques Kilchoer
[mailto:Jacques.Kilchoer_at_quest.com]Sent: Monday, March 19, 2001
2:16 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: For You Sticky Developers out there.....
>-----Original Message----- <FONT
size=2>>From: Mohan, Ross [<A
href="mailto:MohanR_at_STARS-SMI.com">mailto:MohanR_at_STARS-SMI.com]
> > Jack, <FONT
size=2>>yea, interesting....got the same >BUT
>i put a get_time call in a package/stored
procedure >and got the problem again.
Jack?!? Here's a little piece of trivia for the day:
Jack is the english "shortened" version of John, which in
french is Jean. Jacques is the french version of
James, so if anything you should call me Jimmy. But I
prefer Jacques. :)
I tried putting the function in a stored procedure in Oracle
7.3.4, 8.0.5, 8.1.6 and it was successful each time:
SQL> create table t (n number) ;
Table created.
SQL> create or replace procedure p as <FONT
size=2> 2 the_time number ; <FONT
size=2> 3 begin
4 the_time := dbms_utility.get_time ; <FONT
size=2> 5 insert into t (n) <FONT size=2> 6 values (the_time) ; <FONT size=2> 7 commit ; <FONT size=2> 8 end ; 9 /
Procedure created.
SQL> execute p
PL/SQL procedure successfully completed.
SQL> select * from t ;
N
 |
 |