Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing db name in java stored procedure
Although this is a kluge, if you are always running it on the same
platform, you could issue a Runtime class call to something like uname
-a on Unix...
micholka_at_web.de (Klaus Micholka) wrote in message news:<40a850a7.0211290642.5710e00c_at_posting.google.com>...
> I have a production and a test oracle 8.1.7 db. The test db is filled
> by a copy
> of the production db.
> The db contains a stored procedure, which comunicates with another
> programm.
>
> The external program wants to know, which is the sending db.
>
> How can the java stored procedure access some identifing data, like
> hostname,
> db name or sid? I can't work with two different stored procedures
> because the productive is copied to the test.
>
> Is there any other way then establishing a connection to the db (which
> db?)
> and select global_name from golbal_name or select * form V$database; (
> I dont have the rights for the last one).
Received on Tue Dec 03 2002 - 08:51:04 CST