Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dynamically generated SQL options?

Re: dynamically generated SQL options?

From: <dbooher_at_my-deja.com>
Date: Wed, 06 Sep 2000 21:56:47 GMT
Message-ID: <8p6eil$jl9$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US