gt;>
>> 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 disclosu
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
-starter.
It is at times also 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
ttp://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 wrote:
> Hi,
>
> I am trying to query an Oracle database
altogether for this
task.
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
ferent depending on who 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
Jared Still
Certi
t others.
Is this being done on an Oracle database?
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 Ev
On Thu, Mar 11, 2010 at 7:24 AM, Lyle Brooks 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 Or
that already does this (couldn't find one), 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
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:
gt;prepare("select 'Today is ' || sysdate from dual union all
select user from dual");
$sth->execute();
while (my ($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
In addition to the advice you have received, I might
suggest that you read all of the user documentation
for both DBI and DBD::Oracle.
You'll be glad you did.
It is a good idea to review it periodically as well.
Which reminds me ...
Jared Still
Certifiable Oracle DBA and Part Time
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
10 ).
>
>
I see lots of help 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 Tim
3s making 8449 calls to DBI::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
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 be
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 wrote:
>
>
> $driver is the driver name,
> possibly defaulted to $ENV{DBI_DRIVER},and may be undefi
/10.2.0
> Can't create define.sql: 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 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-curt
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-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,
ORA-06502: PL/SQL: numeric or value error: character string buffer too
small
ORA-06512: at line 2
When all 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
> 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 co
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
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
even better, make sure it's working.
tnsping
On Jan 16, 2008 11:11 AM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> also make sure the Oracle listener is listening on e.g
> .
> netstat -a | grep 1521
>
> M--
> - Original Message -
> From: "
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
ork right, too bad.
Connections between Oracle 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
--
Ja
2008/1/12 Dr.Ruud <[EMAIL PROTECTED]>:
> "Carville, Stephen" schreef:
>
> > and c.certcrtdate >= to_date('%s','MM-DD-')
>
> Aaargh, you should always use 'YYYY-MM-DD'.
>
>
Except when reality beckons.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
ease 9.2.0.8.0 - Production
With the Partitioning option
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
atabase version.
Try running your script without bind_param against a different version of
the database.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
les, 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
hether
or not it is read only.
I believe this correspond to the ANSI standard SET TRANSACTION REPEATABLE
READ
with the added functionality of not allowing DML when set to READ ONLY.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
${SHELL:-/bin/sh} << `(dd if=/dev/urandom count=200 bs=1
2>/dev/null|LC_ALL=C tr -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?
.
To get an accurate accounting 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.
pooling.
I have 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 Par
):
perl -MDBI -e 'print "$DBI::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
quests, I've 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
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 mul
xplicitly.
>
>
> 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
w 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.
5 3015.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
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 mes
e silent about things that
matter.
> Martin Luther King
>
> Our government can't be bought. The oil companies will never give it
up
> at
> any price.
> My opinion
>
--
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Why are you setting TWO_TASK in the Perl script?
Try running your script without it.
Jared
On 2/23/06, Rhugga Harper <[EMAIL PROTECTED]> wrote:
>
> Here is the perl code to do the same:
>
> $ENV{ORACLE_HOME} = $_oracle_home;
> $ENV{TWO_TASK} = $_oracle_two_task;
> $ENV{TNS_ADMIN}
enter into any contract on
> behalf of Britannia Building Society by email.
> Britannia Building Society is authorised and regulated by the Financial
> Services Authority. Britannia Building Society is entered in the FSA
> register, register number 104879. Britannia Building Society, Britannia
> House, Leek, Staffordshire Moorlands, ST13 5RG.
>
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
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 several
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
>
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
lumn on the database.
=
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 improp
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: http://www.free
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 Or
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 b
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 cause
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 'ins
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 certificate
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.
>
Fu
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 ord
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 goo
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
> s
gt; Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -Original Message-
> From: Tantalo, Christopher G [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 26, 2005 8:57 AM
> To: Jared Still
> Cc: DBI List
>
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 dmg
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 ha
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-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 h
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 laten
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.
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,
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 at
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 vers
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, or
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 th
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
According to your trace file, you need to reset your
ORACLE_HOME to point to the 9.2 installation.
Jared
On Fri, 2004-11-05 at 04:04, [EMAIL PROTECTED] wrote:
> Dear Sir,
>
> after succesfully using Oracle-DBD on a machine running RedHat 8.0 with
> Apache 1.3, Perl 5.6 and Oracle 8.1.7 I though
> 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
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 811
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-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. No
On Wed, 2004-09-22 at 15:19, Lamb Joseph wrote:
> I bagged SQLite and used an Oracle DB.
>
You may want to check out 'execute_for_fetch', though I confess
I have not compared exe times, it may be worth investigating.
Jared
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.
>
. It would be nice to solve 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
> (5
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
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 attem
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
> 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();
>
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.
J
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
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-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 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
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,
1 - 100 of 204 matches
Mail list logo
