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

[Mohan, Ross]

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

Thanks, Jimmy.

 

:-)

-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: For You Sticky Developers out there.....

>-----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