Home » RDBMS Server » Enterprise Manager » Oracle SQL statement 00900 error
Oracle SQL statement 00900 error [message #67895] Fri, 28 June 2002 08:03 Go to next message
Anna Middleton
Messages: 1
Registered: June 2002
Junior Member
PLEASE HELP - If I run the following SQL statement connected to svrmgrl/sqlplus as system/manager as sysdba on Oracle it works ok:
select GMMCU, GMOBJ
from testdta.f0901
where GMPEC=' ';

but if I add the same SQL statement to the following to a unix file:
ORA_OWNER=oracle
export ORA_OWNER
svrngrl << !!
connect internal
sqlplus
select GMMCU, GMOBJ
from testdta.f0901
where GMPEC=' ';
exit
!!

and execute the file it fails with ORA-00900: Invalid SQL statement, as I am not a great Oracle expert - What am I doing wrong ?
Re: Oracle SQL statement 00900 error [message #67896 is a reply to message #67895] Fri, 28 June 2002 11:45 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
You need to take out sqlplus:

ORA_OWNER=oracle
export ORA_OWNER
svrngrl << !!
connect internal
REM sqlplus
select GMMCU, GMOBJ
from testdta.f0901
where GMPEC=' ';
exit
!!
Previous Topic: log in to my DB as SYSDBA
Next Topic: Oracle Expert Error ...
Goto Forum:
  


Current Time: Mon May 16 20:01:22 CDT 2022