Pass multiples values to script into sqlplus in Oracle I want to execute the same sql script passing one text every time but I don't know how to it. I want to do it into sqlplus.  

With this select I have the values but I don't know how to pass this values.

 select column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec')))

 LOOP 
   start script.sql column_name;
 END LOOP;


I don't understand your example. I have try to use but it doesn't works. I want to pass both values to "prueba.sql" (one in each execution)

cat prueba.sql
 prompt &amp;1;

SQL&gt; COL column_value NEW_VALUE v_column_value
SQL&gt; select column_value column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec'));

COLUMN_VALUE
--------------------------------------------
Logons Per Sec
Executions Per Sec

SQL&gt; @prueba.sql &amp;&amp;v_column_value
Executions


I want to execute a report inside the prueba.sql each time with one of this values as parameter.

Thanks
You can use COLUMN command in SQL*PLUS as shown below.

SQL&gt; COL column_value NEW_VALUE v_column_value
SQL&gt; select column_name column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec')));

SQL&gt; @"test.sql" &amp;&amp;v_column_value


Documentation: COLUMN in SQL*PLUS