t;
>> The information contained in this electronic mail transmission is
>> intended only for the use of the individual or entity named in this
>> transmission. If you are not the intended recipient of this transmission,
>> you are hereby notified that any disclosure, c
ciate it or if
> you can point me to someone.
>Thanks,
>Ajay
>
>Ajay Kumar
>
>Applications Developer
>
> Prince William County Public Schools
>
> - End forwarded message -
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Eva
an indication that the poster has not yet really
investigated the problem too deeply.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
://catb.org/~esr/faqs/smart-questions.html
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Tue, May 11, 2010 at 12:25 PM, tech422 craym...@bu.edu wrote:
Hi,
I am trying to query an Oracle database
.
If you want advice on how to use sqlplus in both linux and windows, there
is a better forum for that: http://www.freelists.org/webpage/oracle-l
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
you ask.
If someone is a Moderator and allows or denies posts before they are sent
out to the list, then
he or she can be seen as being responsible for the content. Not so good if
someone claims
a post is libelous.
Spammer *are* annoying. Just hit DELETE
Jared Still
Certifiable Oracle DBA
On Thu, Mar 11, 2010 at 7:24 AM, Lyle Brooks bro...@deseret.com wrote:
In reading the DBD::Oracle docs, it seems like it is saying that
Object Collections are supported, but perhaps I am mis-understanding
the docs.
Did you try the example in the docs?
Jared Still
Certifiable Oracle DBA
?
If so a much better way IMO would be to use the DBMS_LOCK
package that is part of the database.
The package has the advantage of automatically releasing a lock
when the session ends.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page
), or if
there are problems that could cause this to blow up.
Have you taken care to test in a environment that will push it as hard as
production?
Have you made sure that some clients disconnect at inopportune times?
Just providing a few things to consider. :)
Jared Still
Certifiable Oracle DBA
I am using 32 bit Perl on 64 bit servers, as there are some
modules that aren't available in 64 bit, such as Win32::Daemon.
If you need to do so, just open a 32 bit command window to
run the 32 bit installer from.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http
($sysdate) = $sth-fetchrow_array()) {
print $sysdate, \n;
}
$sth-finish();
1.609
Today is 11-FEB-2010 16:31:48
SYS
=
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
offered on solving this problem.
What I am curious about is why is it a problem?
Why can you not use a username and password?
Some may say the answers to that question are obvious,
but that may not be the case.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http
Bummer.
Thanks for the explanation.
I was going to recommend using a password server, but
probably not a good idea for multiple personal account
passwords.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
::st::fetchrow_arrayref, avg 1.69ms/call #
spent 3.40s making 8449 calls to DBI::st::execute, avg 403µs/call*
514
); 515
#};516
http://search.cpan.org/~timb/Devel-NYTProf-2.10/lib/Devel/NYTProf.pm
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http
On Thu, 2009-08-06 at 10:23 -0400, Link McGaughey wrote:
...aliasing each of the column names, but this becomes a maintenance
issue when you have alter the selected columns every time there is a
change to the table.
Personally, I would work on stabilizing the design.
Tables frequently
transactions (begin, select for update) go to the master. Database is
Postgresql.
The obligatory question:
What are you really trying to accomplish?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Mon, 2009-06-29 at 15:56 +0530, Dhanashri Bhate wrote:
Hi All,
I have been working on Windows with Oracle DB and Active Perl and done some
DBI coding with DBD::ODBC.
Now I need to move things over to Linux machine ( Red Hat Linux 4 and Oracle
10g.)
I know this is not really a DBI
Just when I thought it was as simple as reading the error message...
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Tue, Jun 9, 2009 at 6:42 AM, Martin Gainty mgai...@hotmail.com wrote:
$driver is the driver name,
possibly defaulted to $ENV{DBI_DRIVER},and may
: Permission denied at Makefile.PL line 1516.
print() on closed filehandle FH at Makefile.PL line 1517.
Looks like you are trying to install DBD::Oracle while logged on as oracle.
You probably need to be root.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Wed, 2008-12-17 at 16:08 +0100, pmonsch...@groupe-casino.fr wrote:
}
My environment is correct :
ORACLE_HOME is correctly set and point to and OCI oracle folder
(10gR2.4 64bit)
This sentence is somewhat confusing.
What exactly is the value of $ORACLE_HOME ?
On Fri, 2008-04-25 at 09:08 -0700, Dunston Rocks wrote:
$ENV{TNS_ADMIN}=
'C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnam
es.ora'; # Also tried replacing these with POSIX-Style paths
$ENV{ORACLE_HOME} = C:\oracle\product\10.2.0\client_2;
$ENV{NLS_LANG} =
On Thu, 2008-05-01 at 11:53 +0100, Tim Bunce wrote:
I found an interesting use for the (undocumented) DBI callback mechanism
recently.
You might find it interesting (in lieu of documentation, for now).
http://blog.timbunce.org/2008/05/01/pay-no-attention-to-that-callback-behind-the-curtain/
On Thu, 2008-04-17 at 21:43 -0400, [EMAIL PROTECTED] wrote:
I just want to get a general feeling of the community on weather the next
version of DBD::Oracle (1.22) should drop support for the
Oracle 8 and
Oracle 9 clients
Though personally I no longer have an 7.x databases to work with,
else fails, read the documentation.
Jared
-- 6502.sql
-- demonstrate common causes of ORA-6502
-- Jared Still
-- See note # 20063.1 on MetaLink
drop table t6502;
create table t6502 ( char_data varchar2(20), number_data number(6) );
insert into t6502 values('100', 1);
set serveroutput
I'm reluctant to build Perl, primarily because there are already 20
other modules that I have already installed into this Perl. Secondly,
if I can't build a Perl C module, what luck am I going to have building
a whole language.
I've made it a standard practice to always install my own copy
On Feb 6, 2008 8:30 AM, Richard Labutis [EMAIL PROTECTED] wrote:
one more question:
why is not possible to build a universal version?
That will likely appear when Oracle provides a universal client.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Mon, 2008-02-04 at 16:52 +0530, Mohammed, Shafi wrote:
Hello,
I am trying to install DBD::oracle package in my machine.
Version?
Please tell me how to resolve this issue.
I know nothing about hpux, do have extensive experience perusing
documentation.
A good start would be to
On Fri, 2008-01-18 at 09:47 -0500, RICHARD FERNANDEZ wrote:
Does moving ORACLE_HOME mean that I need to recompile DBI, or was that
information only used for testing during the install?
DBI has no dependence whatsoever on Oracle.
DBI is DataBase Interface
DBD::Oracle on the other hand is the
even better, make sure it's working.
tnsping SID
On Jan 16, 2008 11:11 AM, Martin Gainty [EMAIL PROTECTED] wrote:
also make sure the Oracle listener is listening on default Port 1521 e.g
.
netstat -a | grep 1521
M--
- Original Message -
From: Jared Still [EMAIL PROTECTED
On Tue, 2008-01-15 at 16:29 -0600, Michael Muratet wrote:
I am trying now to get DBD::Oracle working. The DBI install came off
without a hitch. The DBD perl build and the make worked OK (logs are
at the end). The first attempt at testing failed. I recalled something
I had read about
2008/1/12 Dr.Ruud [EMAIL PROTECTED]:
Carville, Stephen schreef:
and c.certcrtdate = to_date('%s','MM-DD-')
Aaargh, you should always use '-MM-DD'.
Except when reality beckons.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
7 and 9.2 are not supported. A 9.2 client cannot
connect to a 7.3 database, though a 7.3 client can connect to a 9.2database.
We have an app that does this, simply because there is no way around it,
unsupported or not.
See MetaLink note 207303.1
--
Jared Still
Certifiable Oracle DBA and Part
JServer Release 9.2.0.8.0 - Production
Data Base
--
DV2
[EMAIL PROTECTED] SQL
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Fri, 2007-07-20 at 12:34 -0700, Paul Simon wrote:
Again, setting the sql type to SQL_VARCHAR via bind_param solves the error...
Looking back, the problem started when I upgraded the oracle client
(including oracle odbc
driver) from 9i to 10g. There's something not right here - even
running your script without bind_param against a different version of
the database.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
, in the future, I'll definitely check it
out.
dbms_metadata has one nasty flaw - the output must be
manually reformatted to be usable.
Try using DDL::Oracle, as it does work.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-d -c '[:alnum:]')`
ls -l
HTH
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Sat, 2007-03-24 at 00:56 +0530, Samant Kumar wrote:
Hello,
I am trying to install DBD Oracle from a very long time now. I cannot use
PPM as the systems in my company are behind a proxy. I am a novice in both
Have you set the HTTP_PROXY environment variable?
Have you read the README?
::VERSION\n;'
or even:
$ perl -MDBI=99
DBI version 99 required--this is only version 1.52 at
/u01/app/perl/lib/5.8.8/Exporter/Heavy.pm line 121.
BEGIN failed--compilation aborted.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
not used it, but it is designed for your scenario.
You do need a test environment that mimics production
to really test an implementation of this.
http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14212/intro.htm#sthref67
--
Jared Still
Certifiable Oracle DBA and Part Time Perl
requires parsing the data in /proc/PID/maps
and determining how much memory is in use. This is what pmap and ps
should do. They both double or triple count a few numbers.
The point is, you don't really know how much memory you are using if
this is a linux box.
--
Jared Still
Certifiable Oracle
uploaded an Oracle Troubleshooter HOWTO to my
homepage, that should help you if you get Can't load Oracle.DLL and
similar errors with DBD::Oracle.
URL http://www.alexander-foken.de/downloads.html
Alexander
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
.
Best Regards,
Sasikala,
GPSy Development Team,
HP-GDIC,Chennai,India,
Ph:+91-44-3985 3015.
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 24, 2006 11:21 PM
To: Elangovan, Sasikala
Cc: dbi-users@perl.org
Subject: Re
On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote:
I'm not quite sure how to describe this problem.
When I make a call to an Oracle 10g database using DBI and SQLRelay (for
connection pooling) I seem to get results from the previous SELECT.
Is the Oracle version 10.2?
Are
On Wed, 2006-08-23 at 11:23 -0700, ManKyu Han wrote:
Is there some optimization that I should do?
Yes
#
# This will populate Table
# mkUtil is nothing but collection of simple functions like random number
generator
# and printing time and
.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
if that is the exact problem here, but that is where I would
start.
Current versions are 5.8.x.
Many folks consider it best practice to install a separate version of Perl
for use with database work.
Modifying (such as adding modules) the version used by the OS is not
generally a good idea.
--
Jared Still
House, Leek, Staffordshire Moorlands, ST13 5RG.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Why not just download from
ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3 ?
On Fri, 2005-12-16 at 11:29 -0600, amonotod wrote:
Hey all...
I've previously built DBD::Oracle 1.15 and 1.16 against Oracle 9i and Perl
5.8.0 and 5.8.3; those builds went flawlessly, I seem to recall. But, my
Not using tnsnames.ora?
Using Oracle Names?
You are likely running into a bug with Oracle 9.2.
There are at least 2 documented bugs for this, probably
more undocumented ones.
The workaround? Use a tnsnames.ora file.
Seriously. There is so far, no fix for it.
I've had to do this on
It appears that you are seeing the parse done by DBD::Oracle
to describe the table.
Look at the DBI docs for ora_check_sql. Turn it off and
the extra parse should go away.
Jared
On Thu, 2005-12-08 at 11:00 -0500, Peter Santos wrote:
Dear users,
I'm hoping to get some insight into why oracle
On Tue, 2005-12-06 at 15:43 -0800, Joe Slagel wrote:
Hi Tim Folks,
We've found a interesting problem when inserting multiple rows into a
table containing two CLOB columns. The second execute() hangs and
Oracle never responds. The execute() hangs only when the character
sizes of the two
.
=
On Fri, 2005-10-28 at 20:41 +0100, Tim Bunce wrote:
Last time this came up (which was recently) Jared Still [CC'd]
reported that he'd found several non-perl related references to this
error on Metalink. They were related to improper NLS settings.
Perhaps Jared, or someone
Though I very much like Perl, sqlplus sometimes
is the correct tool to use, even from cron.
If you are on at least version 9 of Oracle, it
becomes an even better tool, as external tables,
bulk binds and the 'FORALL' statement can load
data extremely quickly and efficiently.
see:
On Mon, 2005-10-10 at 06:09, Gupta, Razat wrote:
I was running DBI on my machine and it was fine.
I was accessing remote Oracle servers using DBD::ORACLE.
Which indicates that Oracle was already installed on your machine.
Otherwise, DBD::Oracle would complain.
But when I had installed
On Wed, 2005-10-05 at 10:46, Moon, John wrote:
The following code produces this error - ORA-01026 - after 2,000 inserts...
Any help or suggestions will be greatly appreciated.
You should troubleshoot this with the help of Oracle Support if you have
it.
There are a number of possible causes,
On Thu, 2005-10-06 at 19:42, Jonathan Leffler wrote:
My understanding is that a Perl with multi-threading where you do not use
the multithreading should be as stable as a Perl without the multithreading.
However, there's a chance that some modules may not be so happy. OTOH, DBI
shouldn't be
This seems to be bug 1400539.
See MetaLink document 241358.1 for an explanation and workarounds.
HTH
Jared
On Fri, 2005-07-29 at 01:00, Teemu Kivioja wrote:
Hi,
Even though character encoding issues have been discussed also here, I still
cannot figure out what is going on in my system.
The current versions of both will work nicely.
Both are found on CPAN.
All details that are normally necessary are found in the fine
documentation that is bundled with the source code.
Further details may be found at http://google.com.
Jared
On Sun, 2005-07-24 at 23:42, Ata Raja wrote:
Hi,
driver://user:[EMAIL PROTECTED]:port/instance
I haven't been following this too closely, so my apologies
if already mentioned.
This connect string is very much like the new Easy Connect
Naming method in Oracle 10g.
eg. sqlplus scott/[EMAIL PROTECTED]:port/service
Note that it is not
I use a (Perl) password server for this.
Passwords are stored encrypted in a configuration file.
Clients authenticate with the server, and receive a requested
password (encrypted) across the network, if the client is
entitled.
The user authentication is rudimentary, but it works.
SSH
On Mon, 2005-07-04 at 17:08, Gerardo Santana Gómez Garrido wrote:
OK, let's see what I can do. Just taking time from the project to
think of rewriting reports is already a luxury, and there's a
competing alternative called SQR. I have to test it too and see how
much time it takes.
Funny, I
On Mon, 2005-06-13 at 09:44, Moon, John wrote:
... jwm wrote
IF this is the way you choose to build your update/insert statements
please be aware that date formats vary by session... So you would need to
either do a to_date function and different mask for each date you handle or
set the
Google this: oracle sql Underneath the Mango Tree
The URL to an excellent article by Stephane Faroult will
be the only hit.
If you click the URL, you will need to be a member of IUOG.
If you click 'View HTML' the article itself will appear, though
not well formatted.
Such is the magic of
ORA-1222 is MAXINSTANCES of %s requires MAXLOGFILES be at least %s,
not %s which is incurred during database or controlfile creation.
Maybe a different error message you are seeing?
IAC, an Oracle 9.2 client cannot connect to an Oracle 7 database, so
maybe an upgrade of the database is in
.
-Original Message-
From: Tantalo, Christopher G [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26, 2005 8:57 AM
To: Jared Still
Cc: DBI List
Subject: RE: LongReadLen issue
Which manual did you FR this from?
---
Just Your Friendly
Here's a fun and slightly obfuscated method to do that:
my $usql=q{select username from dba_users};
my $aryRef = $dbh-selectall_arrayref($usql);
my @users = map { $aryRef-[$_][0] } 0..$#{$aryRef};
my $newSql = q{select from users where username in ('}
. join(q{','},@users) . q{')};
print
On Thu, 2005-05-26 at 07:05, Ronald J Kimball wrote:
Regardless of the method you use to construct the query, you should not
quote the values by hand. This approach will fail if a value contains a
single quote, and may make you vulnerable to SQL injection attacks.
Yes, thank you. A bad
A little RTFM is in order.
Try max(dbms_lob.getlength(mc.mc_long_description))
Jared
On Thu, 2005-05-26 at 07:27, Tantalo, Christopher G wrote:
I am not totally sure that is the issue. Using sqlplus and TOAD to just
do the simple select
SELECT MAX(mc.MC_LONG_DESCRIPTION)
FROM
On Thu, 2005-05-12 at 07:21, Ian Harisay wrote:
If this takes 2 minutes then your problem is with your database, not
Perl. Which means you'll need to look at query optimization. Not code
optimization. Your query optimization may also include tuning your database.
Things like network
On Thu, 2005-05-12 at 07:48, Job Miller wrote:
a 20k row fetch via an index would be a bad idea.
Without knowing more about the data and schema, you
can't really claim that.
If the 20k rows are from a billion row table that is
not partitioned, an index may be a good idea.
It depends on
On Wed, 2005-04-20 at 12:57, Michael Styer wrote:
Thanks for that. That's definitely the limit I'm running up against. Now
if I could only figure out how to close my cursors...
Why don't you just close them the same way you opened them:
via PL/SQL.
Maybe an example is in order.
DBD::Oracle does support inline views,
nested queries, and just about any other form
of SQL thatyou can pass to it.
My best guess is that you need to use sql_tags
( see the docs ) to explictly state the type
of the column generating the error.
On Wed, 2005-03-16
Click your heels twice and utter the incantion
There's no place like home. There's no place like home.
On Wed, 2005-03-09 at 13:02, James B Schmidt wrote:
Please remove me from the list.
Thank you
__
James B. Schmidt, Ph.D.
Hi Nelson,
Is there an error message or messages the result from this script?
For all we know, your failure to commit is just a personal problem. :)
Also, you are committing every row. Please stop doing that,
your database will love you for it.
Just issue one commit at the end of the loop,
On Fri, 2005-02-04 at 07:06, Adam Stoller wrote:
Once we fixed that, we found that with ORACLE_HOME being protected (750
directory access) using 'sudo make' wasn't sufficient - and we had to
change the access rights on ORACLE_HOME to 755
A better way to do this might be to build a version
Or even my $sql=q{select to_char(mf.ROW_MOD_DATE,'MM/DD/') Modify
Date from table1 mf}
Jared
On Fri, 2004-12-24 at 19:10, David N Murray wrote:
If you are trying something like
my $sql = select to_char(mf.ROW_MOD_DATE,'MM/DD/') Modify Date from
tbl mf;
then its perl that's
On Wed, 2004-11-24 at 06:43, Tim Bunce wrote:
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in rdbms/demo and
one in rdbs/public
I have only one, in $ORACLE_HOME/rdbms/public.
Jared
It was working fine with oracle 8.1.6 and 8.1.7 I guess some configuration
settings have to be done for my perl to execute the stored procedure written
in oracle.
So, does the stored procedure work correctly when called stand-alone
from sqlplus?
My guess is that it doesn't.
Here's what may
On Fri, 2004-10-22 at 14:47, Ravi Kongara wrote:
I got to try this in terms of performance. I'm running this program for
more than 100 different tables parallelly. So i have to create so many
temp tables at a time and populate them with the given data and then
run the query by joining with
On Mon, 2004-10-18 at 10:16, BAXTER, LINCOLN A wrote:
Most people with experience with Oracle know that opening oracle connections
is SLOW!
Really? I've never noticed. Unless I'm connecting to a
database over a slow WAN.
Here's a connection time to a database on a laptop through
an 811g
On Mon, 2004-09-27 at 12:01, David wrote:
Hi,
I have oracle 8 personal edition with OCI80 installed on WinNT.
I have DBD-Oracle-1.15 and running in cygwin downloaded in the last
90 days. I also tried versions 7 through 14.
perl Makefile.PL can't find the Oracle version number. Not a
On Tue, 2004-09-14 at 01:47, Tristan Greaves wrote:
Hi there Tim,
We are using DBD::Oracle as part of our web site here, and are
experiencing some Oracle crash issues. We are trying to pin down the
cause and I was wondering if you have had any similar issues raised
to you.
Here are the
this situation so if it comes
up again, I can handle it on the fly.
Thanks for your consideration, Jared.
Christopher R. Marbach
Data Quality Coordinator
Pharmacy Analytical Services
Kaiser Permanente
8-345-2485
(562) 401-2485
Jared Still [EMAIL PROTECTED]
09/06/2004 09:27 PM
On Wed, 2004-09-22 at 15:35, Reidy, Ron wrote:
Well, since you're using Oracle, modify your do() and prepare() statements as
follows:
$dbh-do(sql statement, {ora_check_sql = 0}) ...
$dbh-prepare(sql statement, {ora_check_sql = 0}) ...
And you will make your DBA happy.
Unless I'm
my $start_num = $dbh-selectrow_array( select my_id_seq.nextval from
dual);
my @seq = ( $start_num..100,000 ); # some end number
$sth-prepare ( insert into foo (my_id, data) values (?,?) );
$sth-bind_param( 1, shift(@seq) );
$sth-bind_param( 2, bar);
$sth-execute();
the 'select from
On Tue, 2004-08-31 at 07:36, Reidy, Ron wrote:
Use a before insert trigger to populate the column.
Triggers have the cachet of being a neat way to
automatically populate key columns, and I have
used them many times myself.
They are also much slower than the posters original code.
Jared
On Wed, 2004-09-01 at 17:46, [EMAIL PROTECTED] wrote:
Hello, I'm new to the list and am experiencing an issue that I hope some
of you all have dealt with previous and can lend me some advise on.. or
supply a possible fix.
Perl 5.6.1 with DBI module 1.32 operating on AIX 4.3. I'm
On Thu, 2004-08-26 at 16:55, Tim Bunce wrote:
An even more mature, and hopefully even more final, release candidate
of DBD::Oracle 1.16 is available for testing at:
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc7-20040826.tar.gz
Nice one Tim!
It now finds the 10g libs.
Jared
On Wed, 2004-08-18 at 08:14, Xinyu Wen wrote:
I have a query like this:
select a from some_table where b in (?);
I neet to bind 1000 items for b which likes:
select a from some_table where b in ('abc','bcd','acd',x1000);
how can I bind this many parameters without actually put
On Sat, 2004-08-14 at 11:53, Harald Fuchs wrote:
Why do you want to use Perl for that? Every DB has some export
feature that's optimized for exactly what you ask for.
You are obviously not an oracle user.
Jared
On Fri, 2004-08-13 at 11:05, charlie cs wrote:
The following perl script will dump entire table to a
flat file, much faster than sqlplus spool.
I don't believe Oracle was mentioned.
Please test it in your case and let me know your
result.
It will be even faster with $dbh-{RowCacheSize} =
On Sat, 2004-08-07 at 15:32, Tim Bunce wrote:
A mature, and hopefully final, release candidate of DBD::Oracle 1.16
is available for testing at:
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz
RH 8.0
Oracle 10.1
DBI 1.42
I found that 1.16 could not determine the
See comments inline:
On Tue, 2004-08-10 at 12:53, [EMAIL PROTECTED] wrote:
Hiya,
I just finished installing oracle 9.2i on Redhat 9 (Complete client software group)
and now I am trying to install DBD:Oracle. It isnt going to well.
My Environment variables are all set.. Oracle_home,
On Wed, 2004-08-11 at 09:34, Xinyu Wen wrote:
Hi,
I would like to know if there is a better way to fetch an entire table
to a file (the file has to be tab delimited) instead of using
fetchrow_array function? Fetchrow_array is working fine but slow to
work with a big table.
Thanks,
On Wed, 2004-06-16 at 08:43, Kipp, James wrote:
Your program connects via SQL*net to the DB. At insert time,
you need to fetch a sequence, so you issue 'select
seq.nextval from dual'. Seems harmless enough until ...
1. The select statement must be passed across the SQL*Net
On Thu, 2004-06-10 at 03:08, Silvio Wanka wrote:
Not really. The tip using ALTER SESSION does not works.
Yes, it does work.
Maybe we must
first enable tracing in SQL*NET.
No, you don't.
Our trace location is not specified
in ora.ini, so it should be appear in rdbms/log but does not. We
Dug this up, maybe it will help.
---
There are a number of issues filed with the same ORA-1019 error, each of
which turned out to be related to NLS settings in the environment.
In particular, make sure you have set the appropriate ORA_NLS variable
in your environment. In 7.3.X,
was blocking.
Ronald
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 10:41 AM
To: Ronald J Kimball
Cc: DBI List
Subject: RE: Why won't my script terminate?
Writers don't block readers in Oracle. Not issuing a commit
Though I'm fairly ignorant of SQL server, it seems
to be saying that you have issued a commit that
SS is requiring you to begin a transaction with the
'BEGIN TRANSACTION' statement before attempting to
terminate a transaction.
You might care to peruse the SQL server docs.
...
I found the answer
1 - 100 of 186 matches
Mail list logo