Parameter

[orareddy]

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.

[raghud]

It should be
select * from tab where col = _value;

[raghud]

Sorry I am not putting that Icon .I didn't know how it is getting there . You have use ':' before P_val

[raghud]

'select * from tab where col=_value;'