problem in spool command

[prasad joshi]

hello

I am writing code to store output of sql in txt or excel

I have tried following code

but it gives me error that

ORA-00900: invalid SQL statement

spool output.txt
select * from emp;
spool off;

is script runner required for executing this code???

am I using spool command correctly???

Please help me.....

[Rabbit]

Spool is a SQL Plus command. It can note be used in PL/SQL. Confirm that you're using SQL Plus and that the spool command is outside the PL/SQL block.

[prasad joshi]

SQL PLUS means????

I will have to use sql server2005 for executing spool command???

I am not getting.

Please Help.

[Rabbit]

SQL Plus is a utility that comes with Oracle.

[debasisdas]

If you do not know what is SQL Plus, please let me know where are you writing all your SQL queries .

[prasad joshi]

I am writting in oracle sql editor