Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: dynamically generated SQL options?
Make sure you are using bind variables in your VB code. The will make sure you are reusing the SQL if it is found in memory. Also, if you are using Oracle Objects for OLE, then you can create a package, procedure or function and call it from your VB code. If you are using ADO and returning more than one column, forget using a package, procedure or function. ADO does not work well with Oracle and you often end up writing many extra lines of PL/SQL code to accomodate it. I recommend OLE option as it is native and much more robust and efficient than ADO.
In article <8p5u1i$jt2$1_at_flood.xnet.com>,
"Jason Kratz" <jkratz_at_rctanalytics.debug.com>
wrote:
> We have a VB app here which has a query form
for the user to fill out.
> Based on those values it dynamically generates
a where clause which it then
> sends to the database. This seems like
something that can't be turned into
> a stored proc but I'm interested if anyone has
any ideas on how to handle
> this in a more efficient way (if any).
>
> Thanks,
>
> Jason
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Sep 06 2000 - 16:56:47 CDT
![]() |
![]() |