>-----Original Message-----
>From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
>
> Jack,
>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
2 the_time number ;
3 begin
4 the_time := dbms_utility.get_time ;
5 insert into t (n)
6 values (the_time) ;
7 commit ;
8 end ;
9 /
Procedure created.
SQL> execute p
PL/SQL procedure successfully completed.
SQL> select * from t ;
N
----------
302773167
