Re: PL/SQL - system calls, random numbers and milliseconds
From: Jonathan Wayne Ingram <jwingram_at_whale.st.usm.edu>
Date: 1995/06/27
Message-ID: <3sp3kv$nad_at_server.st.usm.edu>#1/1
: >Hi,
: >
: >Does anybody know how to do system call within pl/sql?
To my knowledge this can't be done, without a Pro*C program running and receiving signals from stored procedures via Oracle signals and pipes. Oracle doesn't seem to care that this is a popular request. Analysts have readily admitted over the phone that a host command usable from inside stored PL/SQL is one of the more popular requests.
Date: 1995/06/27
Message-ID: <3sp3kv$nad_at_server.st.usm.edu>#1/1
: iwa_at_csi.nb.ca (Ian Allen) wrote:
: >Hi,
: >
: >Does anybody know how to do system call within pl/sql?
To my knowledge this can't be done, without a Pro*C program running and receiving signals from stored procedures via Oracle signals and pipes. Oracle doesn't seem to care that this is a popular request. Analysts have readily admitted over the phone that a host command usable from inside stored PL/SQL is one of the more popular requests.
: >Also is it possible to generate random numbers other than using the
: >time?
Not that I am aware of.
: >Is it possible to get millisecond in pl/sql?
In a sense....use the DBMS_Utility.Get_Time function to
retrieve the timestamp from the database, which returns
in hundreths of a second since some odd date.
CAUTION: This timestamp rolls over to negative values every 497 days, at least on the HP UX version. Oracle's weirdness again.
Hope this has been some help. It sounds like you should just use Pro*C to do these things....
Jonathan Received on Tue Jun 27 1995 - 00:00:00 CEST