Re: How to get version of server connected to without sys authority?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 11 Mar 2004 12:53:01 +0100
Message-ID: <405052ec$0$295$636a15ce@news.free.fr>

"alederer" <alederer_at_gmx.at> a écrit dans le message de news:4050388e_at_e-post.inode.at...
> Hallo!
>
> I have a application written in Pro*C embedded sql which needs to get
> the version of the database to which it is connected.
>
> The best format is like a select version from v$instance.
>
> The Problem is that this select can't be executed as normal database
> user because the v$instance view is not available.
>
> Is there a way in Pro*C embedded sql to get the server version?
> There is a function OCIServerVersion, is it possible to use it in my
> embedded sql code? If yes, how?
>
> Where can I find the necessary informations?
>
> thanks
> andreas

v$version is selectable by everyone.

Regards
Michel Cadot Received on Thu Mar 11 2004 - 05:53:01 CST