pl sql fle help

Hello guys, i am getting trouble in running pl/sql file,
1- i make file with this source code "abc.sql"

declare
v_abc number(10);
begin
select id
into v_abc
from table;
end;

2- then i run this file from sql plus prompt.
@abc.sql

the problem is here it is not working, it shows this next line (8), as in code, there are 7 lines.

so how i can run this file , and print the value of v_abc,
thanks
[469 byte] By [punjabian263] at [2007-11-18 19:07:06]
# 1 Re: pl sql fle help
Hi,

Just try this.

declare
v_abc number(10);
begin
select id
into v_abc
from table;
end;
/

Add '/' as 8 th line.

Ashish
bashish at 2007-11-9 13:37:26 >