Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: server sysdate manipulation
hello,
In article <2465A05A033BD111969500805F4BEF5B0BCC9D_at_SULACO>, Cees Van Tilburg <ctilburg_at_ortec.nl> writes:
> I need to test a complex application on a Oracle 7.3/Unix server.
> To be able to complete the test in a reasonable time I must be able
> to manipulate the systemdate in order to trigger some events which
> otherwise would require weeks of waiting.
>
> Since there are other applications running on the unix-server I it is
> not allowed
> to simply change the systemdate of the server. So I must have something
> which
> manipulates the sysdate for only one specific user or user-proces.
>
> Is this possible under Unix or ORACLE? Or do I have to specify a
> function which
> increases/decreases the sysdate by a number of days and use this instead
> of the
> sysdate function?
>
> We are still in analysis stage so we have the freedom to choose whatever
> solution without regard
> of existing code.
>
implement a packaged (or a simple) function that simple returns the sysdate in
the production system and returns whatever is in a specific table in the test
system [so you can easily manipulate the "system" date during test].
this will work.
> Please post whatever solution comes to mind, I will repost a resume.
>
> regards,
>
> Cees van Tilburg
> ctilburg_at_spamortec.nl (remove...spam)
>
HTH
peter
Received on Sun Jun 14 1998 - 14:29:56 CDT