how to pass a parameter to Dynamic SQL script.
ex: test.sql contains....
P_values := '&v_value';
select * from tab where col = p_value;
it's possible passing the value like above.
thanks in advance.
It should be
select * from tab where col = _value;
Sorry I am not putting that Icon .I didn't know how it is getting there . You have use ':' before P_val
'select * from tab where col=_value;'
Click Here to Expand Forum to Full Width