RE: For You Sticky Developers out there.....

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 19 Mar 2001 13:03:04 -0800
Message-ID: <F001.002D0D4A.20010319111551@fatcity.com>

>-----Original Message-----
>From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]
>
> 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 Received on Mon Mar 19 2001 - 15:03:04 CST