Is bind var required in side procedure ? [message #23359] |
Wed, 04 December 2002 04:04 |
Ramki
Messages: 26 Registered: September 2002
|
Junior Member |
|
|
Hi all,
We have SQLs stm inside a procedure block
My doubt is :
using bind variables, not using bind variable for SQL inside procedure block will it make any difference ?
Is bind var required in side procedure ?
for better performance
Thanks
-Ramki
|
|
|
Re: Is bind var required in side procedure ? [message #23364 is a reply to message #23359] |
Wed, 04 December 2002 05:28 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
As far as my knowledge goes,
Bind variable usage is depending upon the requirement of the stored procedure.
some procedures expects a value at runtime, so u will go for bind variables, the same can also be handled by passing it as an arguement from an external application/procedure.
Only thing is decide wether u want to reduce the user interventention.
sai
|
|
|
|
Re: Is bind var required in side procedure ? [message #23375 is a reply to message #23364] |
Wed, 04 December 2002 11:16 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Any static SQL in PL/SQL will use bind variables automatically when a variable is referenced.
create or replace procedure p(p_value in number)
is
v_count pls_integer;
begin
select count(*)
into v_count
from t
where c = p_value; -- this statement will only be parsed once
end;
|
|
|