bind variables in VB using OO4O

Does anyone have examples of how to use bind variables in VB when using OO4O? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: bind variables in VB using OO4O

Hi John , i have mailed a doc . have a look at it . Regards, Prem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Does anyone have examples of how to use bind variables in VB when using OO4O? John -- Please see the official ORACLE-L FAQ: http

Re: Cold Fusion and Bind Variables

is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference. While it is easy to demonstrate this in PL/SQL or Perl, I have no idea

RE: Cold Fusion and Bind Variables

VariablesDear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables

RE: Cold Fusion and Bind Variables

Thanks Suzy, CFQUERYPARM is what he needs. Jared Vordos, Suzy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/13/2004 05:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cold Fusion and Bind Variables

Cold Fusion and Bind Variables

Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables

Re: wait events that indicate lack of bind variables

from client and CPU service time consumption too, because not using bind variables probably means that an application parses more often than it needs to. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta

wait events that indicate lack of bind variables

Which wait events are indications that your missing bind variables? btw, if you want to implement bind variables through a c/c++ middle tier its best to use 'prepared statements'. correct? bind arrays can be issued as prepared statements right? This is when you need to do alot of inserts

Re: wait events that indicate lack of bind variables

[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:24 PM Which wait events are indications that your missing bind variables? btw, if you want to implement bind variables through a c/c++ middle tier its best to use 'prepared statements'. correct? bind arrays can be issued as prepared

RE: wait events that indicate lack of bind variables

1. latch free for the shared pool latch (a shared pool latch in 9i). 2. Indirectly, SQL*Net message from client and CPU service time consumption too, because not using bind variables probably means that an application parses more often than it needs to. Cary Millsap Hotsos Enterprises, Ltd. http

RE: Multiple parses with bind variables

should a query such as this, with bind variables and no literals, be parsed so many times? Other queries in the trace show, for example, 2 parses and 16 executions. And while I'm at it, why does is the parse count shown equal to the SUM of executes and fetches? SELECT BENEFICIARY_FK

Multiple parses with bind variables

Why should a query such as this, with bind variables and no literals, be parsed so many times? Other queries in the trace show, for example, 2 parses and 16 executions. And while I'm at it, why does is the parse count shown equal to the SUM of executes and fetches? SELECT BENEFICIARY_FK

RE: Multiple parses with bind variables

To: Multiple recipients of list ORACLE-L Why should a query such as this, with bind variables and no literals, be parsed so many times? Other queries in the trace show, for example, 2 parses and 16 executions. And while I'm at it, why does is the parse count shown equal to the SUM of executes

using bind variables for procedures/packages

that it uses bind variables? Because it will be executed many times every hour and every day. thanks, benny __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http

RE: using bind variables for procedures/packages

('foo','blah'); end; ' the procedure will be called either in a perl script. How would I change it so that it uses bind variables? Because it will be executed many times every hour and every day. thanks, benny __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy

RE: Multiple parses with bind variables

such as this, with bind variables and no literals, be parsed so many times? Other queries in the trace show, for example, 2 parses and 16 executions. And while I'm at it, why does is the parse count shown equal to the SUM of executes and fetches? SELECT BENEFICIARY_FK, BENEFICIARY_PHONE_PK, PHONE_TYPE_FK

RE: ADO and bind variables (was RE: Performance improvement required :-))

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pardee, Roy E Sent: Friday, June 13, 2003 20:10 To: Multiple recipients of list ORACLE-L Subject: ADO and bind variables (was RE: Performance improvement required :-)) This is interesting--if I use

ADO and bind variables (was RE: Performance improvement required :-))

To: Multiple recipients of list ORACLE-L Why can't you use bind variables? I thought using .Parameters method (property?) of ADODB.Command would use bind variables. I thought it didn't. Any way of checking (other than to get the developers to try it? What function, and where can't you use

RE: Using bind variables with ADO in VB

procedures...In the case of normal SQL, ADO replaces the placeholder with Parameter.Value, so there is no binding on the server side. The way I read that, you can't use bind variables in VB using ADO. Craig Healey -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent

RE: example to use bind variables with OO4O/VB

of code ) for: (B (BHow to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? (B (B..peeped into metalink too. (B (Bcan u give me any other example / URL for the same ???! (B (BTIA. (B (BJp. (B (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B

RE: example to use bind variables with OO4O/VB

, 2003 8:00 PM To: Multiple recipients of list ORACLE-L Guys, can someone give a simple example ( piece of code ) for: How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? ..peeped into metalink too. can u give me any other example / URL for the same ???! TIA. Jp

RE: example to use bind variables with OO4O/VB

to use bind variables with OO4O/VB Date: Thu, 05 Jun 2003 05:44:47 -0800 go to your: %ORACLE_HOME%\oo4o\VB\SAMPLES it has a lot of example which should help Regis -Original Message- Sent: Thursday, June 05, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Guys, can someone give

RE: example to use bind variables with OO4O/VB

a simple example ( piece of code ) for: (B (BHow to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? (B (B..peeped into metalink too. (B (Bcan u give me any other example / URL for the same ???! (B (BTIA. (B (BJp. (B (B (B (B (B-- (BPlease see the official ORACLE-L

Re: example to use bind variables with OO4O/VB

[EMAIL PROTECTED] cc: Subject:example to use bind variables with OO4O/VB Guys, can someone give a simple example ( piece of code ) for: How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? ..peeped into metalink too. can u give me any other example

Using bind variables with ADO in VB

Having read that bind variables will solve all our problems ;-) I've tried to get the developers to use them. There response being: how? I don't know much VB and they don't know what a bind variable is. So I read with interest J Prem's question. Now knowing what to look for, I read further

RE: Using bind variables with ADO in VB

recipients of list ORACLE-L Having read that bind variables will solve all our problems ;-) I've tried to get the developers to use them. There response being: how? I don't know much VB and they don't know what a bind variable is. So I read with interest J Prem's question. Now knowing what to look

AW: Using bind variables with ADO in VB

of list ORACLE-L Betreff: RE: Using bind variables with ADO in VB That's why developping server side code will help as you can bind in PL/SQL...period ! Avoid using thick clients...instead put all your logic in Oracle server side (i.e: write package, procedure and function) Regis -Original

RE: Using bind variables with ADO in VB

I don't THINK so. To quote further the parameters are not bound except in the case of stored procedures...In the case of normal SQL, ADO replaces the placeholder with Parameter.Value, so there is no binding on the server side. The way I read that, you can't use bind variables in VB using ADO

RE: Using bind variables with ADO in VB

] cc: Subject:RE: Using bind variables with ADO in VB I don't THINK so. To quote further the parameters are not bound except in the case of stored procedures...In the case of normal SQL, ADO replaces the placeholder with Parameter.Value, so there is no binding on the server side

RE: Using bind variables with ADO in VB

[EMAIL PROTECTED] Subject: RE: Using bind variables with ADO in VB Date: Fri, 06 Jun 2003 09:04:00 -0800 Yet another reason not to use VB or anything like it. http://www.amazon.com/exec/obidos/ASIN/020177061X Craig Healey [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/06/2003 08:59 AM Please

example to use bind variables with OO4O/VB

Guys, can someone give a simple example ( piece of code ) for: How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? ..peeped into metalink too. can u give me any other example / URL for the same ???! TIA. Jp. -- Please see the official ORACLE-L FAQ: http

Thanks -- Re: example to use bind variables with OO4O/VB

Thanx Ganesh,Jared,Jay,Roy and Chajol. Thanks for the info'. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Oracle position on hints (talking about bind variables)

My first consideration with regards to bind variables is to consider the cost of parsing the query. After all the benefit of bind variables (or at least a major one) is to reduce the number of parses required. If the query is going to be executed so rarely that the parse cost (a fraction

RE: Bind variables

(BBASSI-CHQ) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rivaldi.bahar@b cc: bassi.com Subject: RE: Bind variables Sent by: [EMAIL PROTECTED

RE: Bind variables

TMTOWTDI ... It's everywhere. All these choices. Why do they have to make life so complicated? I'm just curious: How do you turn if off? level(0)? -Original Message- Hi, in 8i etc, you can use dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too. -- Please see

RE: Bind variables

alter session set events '10046 trace name context off' or exec sys.dbms_system.set_ev(sid, serial#, 10046, 0, '') Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 9:29 AM To: Multiple recipients of list ORACLE-L TMTOWTDI ... It's everywhere. All these choices. Why do

Bind variables

Hi Listers, I set the sql trace true in a procedure, let's say the procedure testproc(var1 IN number, var2 IN varchar2). Is there a way to know the value passed to that procedure (the value of var1 and var2) in the trace file ? And also the value of bind variable of each SQL statement in that

RE: Bind variables

In order to see the actual value of bind variables, you need to use event 10046 with level 4. from your procedure do: alter session set events '10046 trace name context forever, level 4' Richard -Original Message- Sent: Monday, February 10, 2003 12:29 PM To: Multiple recipients of list

RE: Bind variables

current delete fetch lock insert open rollback savepoint set sql execute commit forall a single-quoted SQL string -Original Message- Sent: Monday, February 10, 2003 12:59 PM To: Multiple recipients of list ORACLE-L In order to see the actual value of bind variables, you

RE: Bind variables

You might try playing around with the DBMS_SUPPORT package which is loaded with the dbmssupp.sql script in the rdbms/admin directory. dbms_support.start_trace_in_session(SID, SERIAL#, waits=false, binds=true) dbms_support.stop_trace_in_session(SID, SERIAL#). -Original Message- It

RE: Bind variables

savepoint set sql execute commit forall a single-quoted SQL string -Original Message- Sent: Monday, February 10, 2003 12:59 PM To: Multiple recipients of list ORACLE-L In order to see the actual value of bind variables, you need to use event 10046 with level 4. from your

RE: Bind variables

: Bind variables Sent by: [EMAIL PROTECTED

RE: Bind variables

-Original Message- Sent: Monday, February 10, 2003 12:59 PM To: Multiple recipients of list ORACLE-L In order to see the actual value of bind variables, you need to use event 10046 with level 4. from your procedure do: alter session set events '10046 trace name context forever, level 4

Re: Bind variables

Stephen, What version of oracle are you talking about? I didn't find dbms_support in 9.2. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 10, 2003 3:43 PM You might try playing around

RE: Bind variables

You have to load it by running the dbmssupp.sql script in the ?/rdbms/admin directory. -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Bind variables Stephen, What

RE: Bind variables

Subject: Bind variables Hi Listers, I set the sql trace true in a procedure, let's say the procedure testproc(var1 IN number, var2 IN varchar2). Is there a way to know the value passed to that procedure (the value of var1 and var2) in the trace file ? And also the value of bind variable

Re: RE: Bind variables

the dbmssupp.sql script in the ?/rdbms/admin directory. -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Bind variables Stephen, What version of oracle are you talking

RE: bind variables

Hi Nicoll, The importance of bind variables, to use in OLTP application is such that if we use, we survive else one or the other day we would feel uncomfortable over the performance issues and would repent over the scalability of the application. Yes, if we use bind variables, the parser does

RE: bind variables

of using bind variables, the Oracle documentation seems to make very little reference to how to use them(for example the PL/SQL manual) Can anyone point me at any decent documentation on the subject of using bind variables in PL/SQL? John -Original Message- From: Nicoll

RE: bind variables

If you want to show anyone the different in seed between using bind variables and not using them Tom Kyte's Expert one on one got a nice example, it is in chap 2 or 3 I think. George George Leonard Oracle Database Administrator Dimension Data

bind variables

Despite the importance of using bind variables, the Oracle documentation seems to make very little reference to how to use them(for example the PL/SQL manual) Can anyone point me at any decent documentation on the subject of using bind variables in PL/SQL? John -Original Message

RE: bind variables

Separator Author: John Dunn [EMAIL PROTECTED] Date: 9/6/2002 7:38 AM Despite the importance of using bind variables, the Oracle documentation seems to make very little reference to how to use them(for example the PL/SQL manual) Can anyone point me at any decent documentation on the subject

Re: bind variables

You probably already are. You have to go to a lot of trouble to avoid using bind variables in PL/SQL. (I'm too lazy^H^H^H^H busy to find the doc link right now.) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 06, 2002 11

RE: bind variables

the author or title. Dick Goulet Reply Separator Author: John Dunn [EMAIL PROTECTED] Date: 9/6/2002 7:38 AM Despite the importance of using bind variables, the Oracle documentation seems to make very little reference to how to use them(for example

Bind Variables in VB

All, Can anyone provide examples of how to issue an SQL statement in VB using Bind Variables (using DAO or ADO). Many thanks for any responses. Dave Leach Technical Services Claybrook Computing Internal ext * 4992 Phone * 01293 604992 Fax 01293 604029 E-Mail * [EMAIL PROTECTED] The above

RE: Bind Variables in VB

Message- Sent: Wednesday, July 24, 2002 8:30 AM To: Multiple recipients of list ORACLE-L All, Can anyone provide examples of how to issue an SQL statement in VB using Bind Variables (using DAO or ADO). Many thanks for any responses. Dave Leach Technical Services Claybrook Computing

AW: How to change VB code to use bind variables?

Nachricht- Von: Miller, Jay [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 17. Juli 2002 00:08 An: Multiple recipients of list ORACLE-L Betreff: RE: How to change VB code to use bind variables? Hi Jared, Thanks for the suggestion. But I went to www.microsoft.com, clicked on support and searched

How to change VB code to use bind variables?

Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me how to do it. Not being a VB programmer I said I had

Re: How to change VB code to use bind variables?

: Subject:How to change VB code to use bind variables? Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me

RE: How to change VB code to use bind variables?

Hi Jared, Thanks for the suggestion. But I went to www.microsoft.com, clicked on support and searched on the words bind variables oracle visual basic After a dozen Internet Explorer Script errors I got a bunch of links with names like 26jbkjakjbmon That one led to a blank page. Others led

RE: How to change VB code to use bind variables?

did you try google? http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=bind+variables+oracle+visual+basicbtnG=Google+Search [EMAIL PROTECTED] 07/16/02 06:08PM Hi Jared, Thanks for the suggestion. But I went to www.microsoft.com, clicked on support and searched on the words bind variables

Re: Help on using bind variables asp web pages

: Sent by: Subject: Help on using bind variables asp web pages [EMAIL PROTECTED] om

Help on using bind variables asp web pages

Hi, Can anybody give me some examples as to how I can use bind variables in asp pages. Here the developers are using static values for inserting and updating the data due to which the whole shared pool is filled with nothing insert and update statements. They are not able to get any documents

RE: Value of bind variables in tkprof

Hi, TKPROF is not designed to format the event 10046 level 4 data. It can only format the trace of event 10046 level 1 (Read: SQL Trace). If you want to format the higher level trace file you need to use *itprof* (Check www.unal-bilisim.com ) *sparky* Hotsos profiler (Check www.hotsos.com).

RE: Value of bind variables in tkprof

Mike - Haven't used this, so I will be interested in how you come out. If you set trace level to 4 or 12, as in alter system set timed_statistics = true alter session set events '10046 trace name context forever, level 4' Then the trace file that is produced should have your bind values. I'm

RE: Bind Variables

which should not generate histogram information. I have even used the INDEX, FIRST_ROWS, and ALL_ROWS hints. None made a difference. I regenerated the statistics on all tables of a particular slow query with bind variables and it didn't make a difference either. Our platform is red hat linux 6.2

Re: Bind Variables

Danny, I'll bet my morning cheese danish that when you changed the SQL from using literals to bind variables, the execution plan changed. Just pull each SQL statement and run it in SQL*Plus, one version of it with literals and the other with bind variables. The difference in your web page

RE: Bind Variables

Danny, Have you tried generating explain plans with and without bind variables and comparing them? That should help you identify if it's truly related to bind variables. What are the wait events for the queries that are running slower? HTH, -- Anita --- Danny Hughes [EMAIL PROTECTED] wrote

RE: Bind variables v. cursor_sharing = FORCE

Hi Greg and list, I'm not convinced of John's conclusion that 'cursor_sharing' = FORCE outperforms bind variables. Some months ago I tried to reproduce John's results and was not able to, despite trying several different variations on the tests. Tom Kyte claims that 'cursor_sharing' is about

RE: Bind Variables

tables of a particular slow query with bind variables and it didn't make a difference either. Our platform is red hat linux 6.2 and oracle 8.1.7. [EMAIL PROTECTED] 10/19/01 18:58 PM I have heard of it. Its a concern. However, with hints you can solve some of your problems. And then you could

Bind Variables

--CIVUFTDKZVQDOGJWYCGU Content-Type: multipart/alternative; boundary=HALPYZPZYFFYCGAKLKOY --HALPYZPZYFFYCGAKLKOY Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I have a question about using bind variables. It is my

Re: Bind Variables

Danny, Were you using histograms? Histograms do not work on bind variables, they only work on literals. I'm sure others will have more to say on the topic but that is one tidbit that I do have experience with on bind variables. Cherie Machler Oracle DBA Gelco Information Network

Re: Bind Variables

Danny, It sounds like when you ...moved to bind variables... you did two things: 1. Switched to using CBO 2. Changed your application to take advantage of the bind variables. I have never heard of switching to bind variables making things slower (and can not imagine when it would make it so

Re: Bind Variables

Danny, It sounds like when you ...moved to bind variables... you did two things: 1. Switched to using CBO 2. Changed your application to take advantage of the bind variables. I have never heard of switching to bind variables making things slower (and can not imagine when it would make it so

Re: Bind Variables

Danny, It sounds like when you ...moved to bind variables... you did two things: 1. Switched to using CBO 2. Changed your application to take advantage of the bind variables. I have never heard of switching to bind variables making things slower (and can not imagine when it would make it so

RE: Bind Variables

recipients of list ORACLE-L Danny, It sounds like when you ...moved to bind variables... you did two things: 1. Switched to using CBO 2. Changed your application to take advantage of the bind variables. I have never heard of switching to bind variables making things slower (and can not imagine when

Re: Bind Variables

Danny, Bind variables are nearly always better than literals in your SQL. The one exception I can think of is if you are making using of histograms, but those aren't often used in OLTP type apps. Without sitting down and analyzing what was taking place, all anyone can do is guess. If you

Re: Tracing a sql statement also to include bind variables

,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden

RE: Tracing a sql statement also to include bind variables

] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en

RE: Tracing a sql statement also to include bind variables

set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody

RE: Tracing a sql statement also to include bind variables

: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack

RE: Tracing a sql statement also to include bind variables

. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e

Tracing a sql statement also to include bind variables

Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend

Re: Tracing a sql statement also to include bind variables

12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack

Re: Tracing a sql statement also to include bind variables/SOLVED

session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can

latch free waits on LIBRARY CACHE latch and bind variables

Can someone please explain how to monitor latch free waits on LIBRARY cache and provide examples of using bind variables. THE PL/SQL reference does not seem to make much reference to bind varaiables John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn