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 &1;

SQL> COL column_value NEW_VALUE v_column_value
SQL> 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> @prueba.sql &&v_column_value
Executions

```

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

Thanks