Hi,

how to pass a parameter to Dynamic SQL script.

ex: test.sql contains....

Declare

P_value varchar2(10);

P_values := '&v_value';

Begin

select * from tab where col = p_value;

end;

it's possible passing the value like above.

thanks in advance.