Parameter substitution question

From: Ariel Kirson <arielk_at_exlibris.co.il>
Date: Mon, 10 Aug 1998 13:14:43 +0300
Message-ID: <35CEC813.3EAB5652@exlibris.co.il>

Hi all,

I recently posetd a similar question, without any sample code. I hope this time it will be more clear. I have written the following script (monrep1.sql) :

declare

    this_month  char(3) := to_char(SYSDATE,'Mon');
    last_month  char(3) := to_char(add_months(SYSDATE,-1),'Mon');
    this_year   char(4) := to_char(SYSDATE,'YYYY');

begin

@monrep &this_month &last_month &this_year; end;

When I run this script (@monrep1) I am prompted for the values of this_month, last_month and this_year. How can I send the values of the variables to "monrep.sql" ?

Thanks in advance,

Ariel Kirson
Ex Libris. Received on Mon Aug 10 1998 - 05:14:43 CDT