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>

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?


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

Original text of this message