Variables in TOAD, New to Oracle

From: Jim <jdz99_at_hotmail.com>
Date: 24 Jun 2004 12:33:59 -0700
Message-ID: <3eed9d77.0406241133.70fbb814@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 Received on Thu Jun 24 2004 - 14:33:59 CDT