Home » SQL & PL/SQL » Client Tools » BIND VARIABLE..URGENT
BIND VARIABLE..URGENT [message #25961] Wed, 28 May 2003 15:15 Go to next message
Sunny
Messages: 25
Registered: November 2001
Junior Member
create or replace procedure f1(a in number) as
begin
insert into test values (a); /* Line 3 */
end;

Is the insert statement in line 3 parsing the statement only once, or is there any way that I can use bind variable to make this insert efficient ???
Re: BIND VARIABLE..URGENT [message #25965 is a reply to message #25961] Wed, 28 May 2003 16:00 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The statement will be parsed only once - every reference to a variable in PL/SQL is a reference to a bind variable.
Previous Topic: Deleting multiple table values
Next Topic: How to pass SQL "create DIRECTORY TMP_DIR as 'c:\courses\cs601'" in Java to Oracle?
Goto Forum:
  


Current Time: Tue Aug 11 08:37:17 CDT 2020