VB - API call to execute procedure, not using bind variables?
From: Dave <David.C.Watson_at_gmail.com>
Date: Mon, 27 Oct 2008 11:10:36 -0700 (PDT)
Message-ID: <435d3692-162a-4625-b02f-4647a7f4ebf6@64g2000hsu.googlegroups.com>
Date: Mon, 27 Oct 2008 11:10:36 -0700 (PDT)
Message-ID: <435d3692-162a-4625-b02f-4647a7f4ebf6@64g2000hsu.googlegroups.com>
We are executing the below statement through a visual basic API and
it's executing the SP with the literal values instead of bind
variables, thus filling up our library cache with multiple unique
statements and hard parsing over and over and over again...
Does anyone know how we can change the code in VB to pass it to Oracle and use bind variables?
Thanks
SCHEMA.STORED_PROC('" & v_ID & "', '" & CStr(Format(v_RepBeginDate,
"dd-MMM-yyyy")) & "', '" & CStr(Format(v_RepEndDate, "dd-MMM-yyyy")) &
"', " & sched_def_inst & ");
Received on Mon Oct 27 2008 - 13:10:36 CDT