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
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
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
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
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
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
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
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
[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
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
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
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
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
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
('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
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
-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
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
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
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://www.orafaq.net
, 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
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
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
[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
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
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
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
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
]
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
[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
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
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
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
(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
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
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
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
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
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
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
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
: Bind variables
Sent by:
[EMAIL PROTECTED
-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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
:
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
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
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
:
Sent by: Subject: Help on using bind variables asp
web pages
[EMAIL PROTECTED]
om
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
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).
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
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
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
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
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
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
--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
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
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
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
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
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
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
,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
] 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
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
:
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
.
--- [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
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
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
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
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
86 matches
Mail list logo