|
From: Drav S. <hol...@re...> - 2011-12-22 14:47:32
|
Matheus Garcia wrote:
> First of all, forgot to say, but I was using 3.1, now I upgraded to
> 3.3.0. Running on Linux.
Well you are now on latest version with 3.3.0 :)
> I tried
> SELECT :var FROM dual
> and squirrel asked me for the value of var, very good, thanks!
>
> Then I tried the code:
> DECLARE
> v1 NUMBER(3);
> BEGIN
> v1 := 3;
> select v1 from dual
> END;
> /
>
> After adding the slash in the end, instead of
> "java.lang.IllegalArgumentException: No SQL selected for execution.",
> I'm getting the following error:
>
> Error: ORA-06550: line 7, column 1:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:
You _may_ need to load the oracle plugin, which again is under
Plugins -> Summary and is simply called 'oracle' (but as far
as I know that just enables things like the database output window).
If I run the statement:
DECLARE
v1 NUMBER(3);
BEGIN
v1 := 3;
select v1 from dual
END;
/
I get:
Error: ORA-06550: line 5, column 2:
PLS-00428: an INTO clause is expected in this SELECT statement
SQLState: 65000
ErrorCode: 6550
Position: 991
.. all procedural oracle code uses SELECT INTO. However, if I do:
DECLARE
v1 NUMBER(3);
BEGIN
select 3 into v1 from dual;
dbms_output.put_line(v1||chr(13));
END;
/
I get '3' in the oracle output window ('View Oracle Database Output'
quick icon opens this up)
Regards
D.
|
