OraFAQ Forum: Unix » spool error

Home » Infrastructure » Unix » spool error (oracle 11.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spool error [message #594331]

Tue, 27 August 2013 08:34

noname34
Messages: 6
Registered: August 2013
Location: visakhapatnam

Junior Member

Hi Friends,

Am facing issues executing the following script

#!/bin/bash
cd /home/oracle
. orcl.env
sqlplus / as sysdba <<EOF
spool /u01/app/oracle/trial.txt
select * from v$flash_recovery_area_usage;
spool off
exit;
EOF

The o/p for the following is

1 SQL> select * from v;
2 select * from v
3 *
4 ERROR at line 1:
5 ORA-04044: procedure, function, package, or type is not allowed here
6
7
8 SQL> spool off
.

The expected o/p is the output of the select query, but its not working so.
I suppose it is not taking characters from the '$' symbol.

Would be greatful if anybody could help me with this .

Thanks & Advance.

Report message to a moderator

Re: spool error [message #594332 is a reply to message #594331]

Tue, 27 August 2013 08:35

noname34
Messages: 6
Registered: August 2013
Location: visakhapatnam

Junior Member

It,s a shell script which i am trying to execute.

Report message to a moderator

Re: spool error [message #594333 is a reply to message #594331]

Tue, 27 August 2013 08:36

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I suppose it is not taking characters from the '$' symbol.

It is almost that; you have to escape the $ with \: \$
I don't see the relation with your title.

Regards
Michel

Report message to a moderator

Re: spool error [message #594338 is a reply to message #594333]

Tue, 27 August 2013 08:55

noname34
Messages: 6
Registered: August 2013
Location: visakhapatnam

Junior Member

oops. sorry for the silly error, but thanks a lot Michel for the solution.

Thanks & Regards,
Ash

Report message to a moderator

Previous Topic:	need to exit if report file is not found
Next Topic:	Oracle installation issue on solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 26 12:26:45 CDT 2026