How to use parameter in sql script pass from unix script?

UNIX for Advanced & Expert Users
1

Hi,

I am unable to use parameter in sql script passed from unix script.

my sql script CREATE_SBI_LIST_GROUP.sql is like this -
-------------------------------

SELECT
SDS.ID "SO_ID",
SDS.SO a1,
sgp.sga__code SGA_CODE,
FROM
sga sga,sales_genl_provision sgp , comm_product_condn cpc ,SO_DETAILS_SBI_GROUP SDS
WHERE
sga.customer_group__code ='&1'  
-- &1 variable passed from unix script it is   not working here
and sga.code = sgp.sga__code
and sgp.sga__code = cpc.sga__code
;

Unix script is as like -
-----------------------------

    group="0023"
    sqlplus -s $USER <<EOF 1>>$SBI_LOG/oracle_error.log
        whenever sqlerror exit 1
        set serveroutput off;
        set echo off;
        set termout off;
        set linesize 600;
        set line 1000;
        set pagesize 5000;
        set newpage 0;
        set feedback off;
        set trimspool on;
        set trimout off;
        set define off;
        set verify off;
        set escape off;
        set colsep "|"
        set doc off;
        spool $SBI_LOG/$SPOOLFILE
        @CREATE_SBI_LIST_GROUP.sql $group  
        spool off;
        quit;
EOF

Please advice me what i am missing here.

Thanks
Amit

2

You turned off variable substitution (in red above).

3

Hi.

Thanks for your help , it resolved my query and i can use & in my script.

Thanks
Amit