Home » Other » 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 ???

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 18 02:20:46 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.