Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Variables in TOAD, New to Oracle
"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:<4aJCc.3984$pE6.2706_at_newsfe4-gui>...
> "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
My mistake, It should have been this,
DECLARE
l_Month VARCHAR2(6) := 'MAY-04';
BEGIN select * from apps.gl_periods_v where period_set_name = 'TUS_445_MTHLY' and period_name = l_Month;
END; I expect the output to go to the grid within TOAD.
Thanks,
Jim
Received on Fri Jun 25 2004 - 10:29:52 CDT