Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Variables in TOAD, New to Oracle
"Jim" <jdz99_at_hotmail.com> wrote in message
news:3eed9d77.0406241133.70fbb814_at_posting.google.com...
> To all,
> I am trying to create a variable that gets referenced many times in
> a query(this is not the complete query) and I want to be able to just
> change the month and year once.
>
> DECLARE
> l_Month VARCHAR2(6) := 'MAY-04';
>
> BEGIN
>
> select * from apps.gl_periods_v where period_set_name =
> 'TUS_445_MTHLY' and period_name = 'MAY-04';
>
> END;
>
> ORA-06550: line 6, column 1:
> PLS-00428: an INTO clause is expected in this SELECT statement
> ORA-06550: line 6, column 1:
> PL/SQL: SQL Statement ignored
>
>
> Tanks,
> Jim
well where do you expect the output to go to, you have to select it into a
variable and then return it to your application
Received on Thu Jun 24 2004 - 17:08:46 CDT