Re: Error accessing package DBMS_APPLICATION_INFO...HELP!@!!!

Hi, this error (?) came about because the client tools ie SQL*Plus is of a later version than the server. The client tool tries to execute DBMS_APPLICATION_INFO which is part of the Procedural Option, I think. However as far as I can remember, this error would not stop your SQL script from running, it is just a warning. 'Select * from v$version;' would show the version of the server, hope this helps.

Regards
Joseph

In article <Pine.SGI.3.95.980712173204.13896A-100000_at_fraser>, Siu Hung <hhchiang_at_sfu.ca> says:
>
>
>Error accessing package DBMS_APPLICATION_INFO
>You may need to install the Oracle Procedural option
>SET APPINFO requires Oracle Server Release 7.2 or later
>ERROR:
>ORA-00900: invalid SQL statement
>
>Hi all:
> I have installed Oracle7 Server Version 7.3.2.1.0 on a IBM
>machine running AIX 4. When I tried to run an SQL script, the above
>error appears. Can anyone please kindly tell me that what is the
>error? How do I install Oracle Procedurl option? Or is there any error
>during my installation of oracle? I am very sure that the Oracle 7 is
>version 7.3.2, so what is the "Release 7.2"?
> Please give me hand, please reply me in email...
> Thank you very much..
>
Received on Mon Jul 13 1998 - 07:50:18 CDT