Help required in passing multiple arguments from a shell script to a pl/sql block

Shell Programming and Scripting
1

Hi, hope everyone are fine. Please find my issue below, and I request your help in the same

In a configuration file, i have a variable defined as below

TEST = 'One','Two','Three'

I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,

In the ksh file
@test.sql ${TEST}

In the sql file, test.sql

select query.........so on..... where par.cde in ('&1')

When I am printing the output of the query, I am finding only one of the strings that is ----> One is present instead of 'One','Two','Three'. My aim is to send the values 'One','Two','Three' into the query so that it has the following

sql query........where par.cde in ('One','Two','Three')

Request your kind help in this.

2

Change the assignment as below and try (add with double quote "....")

TEST = "'One','Two','Three'"