sn't show anything
unusual. I don't know if this is an NLS-utf8 issue. Any ideas?
Thanks,
STH
Trace- level 9 is attached.
--
Scott T. Hildreth <[EMAIL PROTECTED]>
DBI::db=HASH(0x829bca0) trace level set to
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports
bind_param_inout,
but it would require you to use the DB2 Connect Personal Edition or DB2 Connect
Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box.
Dan
On 10/12/05, Stephen More <[EMAIL PROTECTED]> wrote:
If you're willing to upgrade to Perl 5.8.x, then you can use the
latest available version of DBD-DB2 from
http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version
of DBD-DB2 on Perl 5.8.7).
Dan
On 10/7/05, Trent Ohannessian <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I currently have Pe
[EMAIL PROTECTED] wrote:
> Hello,
>
> I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
> And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
>
> Installation may be ok, but when I INSERT double bytes characters,
> I get the following error.
> [IBM][CLI Driver] CLI0109E Strin
s running! Not pretty but it works. Thanks so much. -Alec
Dan Scott wrote:
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw so
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His fix: add -Wl,-rpa
Tim Bunce wrote:
On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote:
Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh->prepare($stmt) or die "Prepare Failed\n";
DBD::DB2 doesn't seem to return false values for failures.
If that's true the
Vance M. Allen wrote:
Sorry if the cross-posting wasn't appropriate, but I need help with this and
am not sure if it's more appropriate to post under CGI or DBI since it
involves both...I want to be sure that I can get help from the best source.
My question is probably a simple answer, but I a
.perlmonks.org/?node_id=492067.
>
> To grab the tarball:
> http://www.vpservices.com/jeff/programs/DBIx-LiveGrid-0.01.tar.gz
>
> I'd value all comments and criticisms, namespace suggestions, etc.
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
har 8 in 'SELECT <*>FROM GIGE WHERE CUSTOMER_SITE
> LIK
> E '%Middletown%'')
>
Are you selecting anything? i.e. Select * from gige
> What may be going on.
>
> Abhay
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
ovided answer.
> > http://www.cpanforum.com/threads/698
> >
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
On 7/19/05, Keith Jackson <[EMAIL PROTECTED]> wrote:
> I have a project that I need to connect to a DB2 database on an AS400
> from a perl application on a Linux box. I've been reading as much as I
> can but have a few questions for those with experience in a similar
> task.
>
> My options appear
r 14.7 Distrib 4.1.11, for portbld-freebsd5.3 (i386)
** Will the current DBD::mysql not work with mysql < 4.0 ?
On Thu, 2005-07-14 at 19:01 +0200, Patrick Galbraith wrote:
> Scott,
>
> First of all, could you please give me some information such as client
> lib version (where
connect from the command line.
Any Ideas?
Thanks.
--
Scott T. Hildreth <[EMAIL PROTECTED]>
gt; -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.1.0.2\" oci8.c
> Running Mkbootstrap for DBD::Oracle ()
> chmod 644 Oracle.bs
> rm -f blib/arch/auto/DBD/Oracle/Oracle.so
>
> LD_RUN_PATH="/u01/app/oracle/product/10g/lib32:/u01/app/oracle/product/10g/r
> dbms/lib32"
> ld -bhalt:4 -bM:SRE
> -bI:/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp
> -bE:Oracle.exp -bnoentry -lpthreads -lc_r Oracle.o dbdimp.o oci8.o
> -L/u01/app/oracle/product/10g/lib/
> -L/u01/app/oracle/product/10g/rdbms/lib/ -lclntsh -lld -lm `cat
> /u01/app/oracle/product/10g/lib/sysliblist` -lm -lpthreads -o
> blib/arch/auto/DBD/Oracle/Oracle.so
> ld: 0711-736 ERROR: Input file /lib/crt0_64.o:
> XCOFF64 object files are not allowed in 32-bit mode.
> make: 1254-004 The error code from the last command is 8.
>
>
> Stop.
> --- end -
>
> i did try to change the lib to lib32. no effect :<
> Please ANY help this this nightmare.
> Andrew
>
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
pilation failed in require at (eval 1) line 3.
> Is there way around this?
> Sorry water mark part of my signature, this site must block messages
> with images
>
>
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
Why do you keep sending the sunwatermark to the list?
I don't see any text just the watermark.
On Wed, 2005-06-29 at 14:42 -0700, Morrison Davis wrote:
--
Scott T. Hildreth <[EMAIL PROTECTED]>
Chris:
This sounds very much like the problem noted under "Hints" at
http://www-306.ibm.com/software/data/db2/perl/:
Having trouble running perl with DB2 UDB Version 8 64-bit for AIX
5.2? Check out this technote.
(http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&uid=swg21181032&loc=
On Wed, 2005-06-15 at 10:38 +0200, Wojciech Pietron wrote:
> Hello Scott,
>
> thank you for your help. But are there any workarounds to this problems?
> Is DBD::Proxy under development? It looks like its code hasn't been
> changed for dozens of months. And now that I am star
alue.
>
> There is no problem to change them when using DBI directly. How can I
> solve it?
>
> Thank you in advance,
> Wojciech Pietron
--
Scott T. Hildreth <[EMAIL PROTECTED]>
I don't think it is specific to Oracle, look at the "Known Issues"
in the DBD::Proxy perldoc.
On Fri, 2005-06-03 at 20:10 +0200, Wojciech Pietron wrote:
> * Scott T. Hildreth <[EMAIL PROTECTED]> [2005-06-03 15:38]:
> > On Fri, 2005-06-03 at 14:46 +0200, Wojci
For the DSN-less connections, see http://www.connectionstrings.com --
great resource.
Dan
On 6/2/05, Martin J. Evans <[EMAIL PROTECTED]> wrote:
> Sharon,
>
> The string after "ODBC:" is usually a DSN name as in:
>
> DBI->connect("dbi:ODBC:mydsn",...)
>
> or
>
> DBI->connect("dbi:ODBC:DSN=myds
This is not the mailing list you're looking for. This mailing list is
specifically about using the Perl DBI with the associated database
drivers (for example, the DBD::DB2 driver, as documented at
http://ibm.com/db2/perl/).
If you want help calling Java applications from a shell script, you
would
h as inserts) that have
> > different placeholder/bind values per execution -- not at all
> > the case here.
> >
> > Can someone verify this observation?
>
> You are correct.
>
> Turn your attention to the RowCacheSize attribute.
>
> Tim.
--
Scott T. Hildreth <[EMAIL PROTECTED]>
I'm sure it will be someday, I know that execute_array is in DBI.
I believe DBD::Pg uses array inserts. As far as I know, DBD::Oracle does
not use the Array Processing yet.
On Tue, 2005-05-03 at 15:35 -0400, Steve Sapovits wrote:
> Scott T. Hildreth wrote:
>
> > Not yet.
&g
Not yet.
On Tue, 2005-05-03 at 15:10 -0400, Steve Sapovits wrote:
> A question from a DBA here: Does DBD::Oracle use Oracle's
> "array interface" to interface to Oracle?
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
;table" are hard words
to seach for. Can anyone help me out?
I just want the info describing the table that I can see in sqlplus.
Mike Scott
QA Software Developer
BBC News Interactive
White City
London
UK
+44 20875 27288
http://www.bbc.co.uk/
This e-mail (and any attachments) is confident
Yup.
On Wed, 2005-03-23 at 11:10 -0800, Jeff Zucker wrote:
> For the past couple of days, I have been getting blank messages from Kim
> Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else?
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
>> Is there any known trick about that?
>
> > Oracle Client is necessary but not sufficient. oci.h and the other
> > required files are usually in Pro*C or OCI or some other package like
> > that. Which package varies with Oracle version and platform.
>
>
>
> Suse Linux 9 Pro and Oracle 9ir2
>
> Any tip?
>
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
2.
I am pretty much confused by all of this. That is until I was
typing this up and noticed I had typo'd an extra '$' on the comparison
line. Maybe now all will be good. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sb
That sounds good, but I am a little confused on exactly how to
achieve that. I'll start poking around, but... Thanks for the pointer
at least.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: CAMPBELL,
rows == 0) {
# print "Entry not found. Inserting into database. \n"; # Testing
line
$sth->bind_param(1, undef);
$sth->bind_param($_+2, $data[$_]) foreach 0..20;
$sth->execute() or print "Data insert failed.";
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL
. \n"; # Testing line
if ($file_val eq $db_val) {
$update = 1;
} else {
$update = 0;
# print "Comparing $file_val to $db_val. \n"; # Testing line
last;
}
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
th->bind_param($_+2, $data[$_]) foreach 0..20;
$sth->execute() or print "Data insert failed.";
<... Remainder snipped ...>
Please help as I am almost there. Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc
# Insert existing data into AllMid_Hist.
shift(@old);
$dbh->do(qq{
INSERT INTO AllMid_Hist VALUES (?".(",?" x 22)."))}, #
This is where I run into issues.
undef,@old,NOW()); # I am not sure how to
structure thi
There is an archive of older ActiveState Perl releases at
http://downloads.activestate.com/ActivePerl that includes 5.8.4.
Dan
On Mon, 14 Mar 2005 09:01:24 -0500, Marina Greenstein
<[EMAIL PROTECTED]> wrote:
>
>
> Jeff,
>
> Any chance you will update repository with 5.8.6 binaries ? Or please
create a second table to hold the changes in providing us
with a tracking mechanism for changes.
I am working on this now, but wanted to throw this out there
seeing as how I am probably going to get stuck shortly. Thanks in
advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED
are("QUERY", { "mysql_use_result" => 1});
or
my $sth = $dbh->prepare("QUERY");
$sth->{"mysql_use_result"} = 1;
On Tue, 2005-02-22 at 08:36 -0600, Scott T. Hildreth wrote:
> Mysql will return all rows by default, you ne
(it was ma mailer causing
> that "error").
>
> also, I'm using:
> DBI 1.46
> DBD::mysql 2.9004
>
> any more ideas ?
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
t; In the context of hosting CGI/DBI applications, what would be the
> pro's and con's of going with Oracle's distribution of Perl as
> verses the version that ships with Red Hat Enterprise Linux?
> Thanks in advance for insights on this.
>
> ...BC
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
routine
check the data type of fields passed-in and handle boolean values
specially, for instance, in a generic way. We use these and actual
queries to the data dictionary of the given database to make the SQL
writer "smart".
Scott Smith
Informatics
Genome Sequencing Center
Washington Univ
http://ftp.esoftmatic.com/DBI/
-Original Message-
From: Lamb Joseph [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 11:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Please Help !!! Unable to install DBD-Oracle ( I am using perl
5.6 on solaris 8)
Please try:
Been working on this for a few days & haven't had any luck:
I have read all of the help files & searched the internet
I still cannot find out what my problem is.
I am running winxp pro (sp2), vis studio.net, oracle 9i (9.2.0.1)
& ActivePerl 5.8., jdk1.5.0
I also ran vcvars32.bat in vis stu
On Thu, 02 Dec 2004 08:53:38 +0100, Cosimo Streppone
<[EMAIL PROTECTED]> wrote:
> Tim Bunce wrote:
>
> > I know what it does, I'm trying to find real examples that demonstrate
> > why people think it's needed. Nick has provided a good one. Any others?
>
> Something like DBIx::DBH is in use in our
With that announcement, lets start a fund drive to DBI Development.
I just contributed at,
http://dbi.perl.org/donate/
...so if you have the means to do so, please contribute. Remember it
is tax deductible, if you live in the US.
STH
On Tue, 2004-11-16 at 08:4
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav LauÅ <[EMAIL PROTECTED]> wrote:
> Hi all!
>
> I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've
> managed it to work from command line.
>
> But when trying to connect to remote database from a mod_perl application the
> $DBI::er
I was going bring this up myself. I had this problem the other day.
To get it working I changed the param names to :p1, :p2, ...etc and
used $sth->bind_param(1, 'foo'). For the return param I had to use the
a :p? as well,
i.e.
my $sth = $dbh->prepare(q{
BEGIN
...bind_param_inout(), typo.
On Thu, 2004-10-21 at 08:36, Scott T. Hildreth wrote:
> Sorry, I am assuming you are using Oracle, are you?
>
> Look for bind_paraminout().
>
> On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
> > perldoc DBD::Oracle will sh
Sorry, I am assuming you are using Oracle, are you?
Look for bind_paraminout().
On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
> perldoc DBD::Oracle will show you how to do this.
>
>
> On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
> >
> >
> > Hi,
>
perldoc DBD::Oracle will show you how to do this.
On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
>
>
> Hi,
> I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File.
> After the stored procedure executes, it returns an out parameter called
> out_v_RECV_FILE_NM.
> I have a p
On Thu, 2004-10-14 at 10:16, Das, Manojit wrote:
> Thanks Scott, I was able to install
> DBI-1.37
> DBD::Oracle-1.14
> with Perl-5005.03
Is it possible to upgrade the perl?
> But one thing I am not sure if the installation is 100% perfect.
why do
You could install DBD::Oracle & DBI on the server which has
the Oracle install and use DBD::Proxy to connect. Or look into
using DBD::JDBC.
On Tue, 2004-10-12 at 16:36, Joseph Bruni wrote:
> Hello all,
>
> Although DBI is great, is there some other sort of DBD module that can
> connect to an O
Ben:
DB2 automatically takes the user ID you logged in with and uses that
as your default schema.
You can issue the "SET SCHEMA" statement to change your default schema
if you want it to be different from your DSN user ID. For example "SET
SCHEMA rick" would automatically prepend 'rick.' to all o
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This
plications
that don't want to talk SQL. Hence, calling it a "SyntaxModel" is
somewhat archaic.
Given this, perhaps DBIx::Mechanize would be more appropriate. YMMV.
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com/
*** New! *** http://www.perlmedic.com/
this
change log testing.
Thanks again for any feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: S P [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 2:27 PM
To: NIPP, SCOTT V (SBCSI); [EMAI
actually empty, but the database is entering the value into the table as
a '0' as mentioned above. Does this problem sound familiar to anyone?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
irst INSERT is the problem one. The second INSERT works
fine. Thanks in advance for any suggestions.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
out.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 4:02 PM
To: 'Reidy, Ron'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subjec
I have a table that has a list of users with numeric user IDs.
The user IDs are not sequential. There are large gaps in the list of
numeric IDs. I want to pick the next unused number beginning at 3000.
How do I do this?
Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E
I am using MySQL. I must confess that I don't believe I have ever
even heard of 'triggers' before.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Ian Harisay [mailto:[EMAIL PROTECTED]
to compare the incoming data to the existing data and then
update accordingly. This seems like it would be an extremely common
thing to do though. I was wondering if someone might know of a module
to do this? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web
Just a curiosity at this point... Is there a way to do this
using the quick quotes method?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Wieland Pusch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September
s is a big deal in and
of itself, just looking for a better way to do this. Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
The suggestion of using Text::CSV_XS was the winner. This is a
very simple module to use. Thanks for the feedback though.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Ravi Kongara [mailto:[EMAIL
Actually, yes. There is a VERY good reason that I am not using
this module...
I had no idea that it existed. Now that I know, I'll take a
peak and see if this will indeed do the trick for me. Thanks a lot for
pointing me in the direction of the easy solution.
Scott Nipp
plit' function. The
next step is to simply populate the database table with the fields.
Here is the 'split' I am currently using.
< ...snip... >
while () {
@data = split(/,\s*/);
print "$data[1]\n";
}
< ...snip... >
Thanks in advance for the
I would, especially if you are starting from scratch. DBD::SQLite-1.04
is using SQLite 3.0, which has more features as stated below.
On Tue, 2004-08-31 at 23:49, Owen wrote:
> On Sat, 17 Jul 2004 10:51:55 +0100, Matt Sergeant wrote:
>
> > Anyone who has read my journal will know that I now have
e(4, "bind %d type %d as %s", i, sql_type,
SvPV_nolen(value));
if (!SvOK(value)) {
sqlite_trace(5, "binding null");
On Mon, 2004-08-23 at 05:03, Dave Cash wrote:
> On Fri, 20 Aug 2004, Scott T. Hildreth wrote:
>
> > Anybody else having proble
Just a follow up. I think I have identified the problems and one
solution and sent them to Matt. Although, I see my first email hasn't
hit the list yet, usually takes 6 hours or so..not sure why..So this
one will follow about 3 hours behind. =8^)
On Fri, 2004-08-20 at 13:37, Scott T. Hil
Anybody else having problems compiling DBD-SQLite-1.03?
On Fri, 2004-08-20 at 11:22, Scott T. Hildreth wrote:
> Hello Matt,
>
>I've been trying to compile DBD-SQLite-1.03 and I get the error,
>
> dbdimp.c:24:4: warning: #warning "No vararg macros - using tra
No parameters, no modifications as of yet. Just a lot of reading
and researching.
Basically...
perl Makefile.PL
make
ERRORS...
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com <http://ldsa.sbcld.sbc.com/>
-Or
27;-b -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT
Locally applied patches:
ActivePerl Build 627
Built under hpux
Compiled at Jun 20 2001 21:42:53
@INC:
/op
I would check out HTML::Mason or Maypole which can use Template::Toolkit
or Html::Mason. Maypole is like Java Struts a MVC(?). Anyway it seems
very easy to setup giving web interfaces to db tables. I have not used
it, worth checking out though. There are articles on perl.com.
On Mon, 2004-08-0
http://www.perlmonks.org would be another good place to post this
question.
On Mon, 2004-08-09 at 11:42, Scott T. Hildreth wrote:
> I would check out HTML::Mason or Maypole which can use Template::Toolkit
> or Html::Mason. Maypole is like Java Struts a MVC(?). Anyway it seems
> ver
I would try setting the $ENV{ORACLE_HOME}, $ENV{LD_LIBRARY_PATH}, ..etc
in the top of the script, i.e.
BEGIN {
$ENV{ORACLE_HOME} = q[/some/path/to/oracle];
$ENV{LD_LIBRARY_PATH} = qq[$ENV{ORACLE_HOME}/lib];
}
On Tue, 2004-08-03 at 16:04, Robert wrote:
> I am also attaching the test
This should be on the dbi-users list. Are you sure all of the
environment variables are set? Can you show the code? The
ORA-12154 is TNS error,
12154, 0, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *A
Tried sending this yesterday, and it never showed up on the list.
Trying again...
-Forwarded Message-
> From: Scott T. Hildreth <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Subject: DBD::Proxy & Setting DBH attributes.
> Date: Tue, 20 Jul 2
I am asking a question, that I'm pretty sure I know the answer to, but
just in case I am missing something,
The following example code works,
use DBI;
my $dbh = DBI->connect('dbi:Oracle:sid', 'user', 'password', {});
$dbh->{FetchHashKeyName} = 'NAME_lc';
my $res = $dbh->selectall_hashref(q{
dibsea.jpg is "cool".
On Sat, 2004-07-10 at 11:55, Dean Arnold wrote:
> Took the liberty of rendering a few of my own
> (now that cooltext is back up).
>
> http://www.presicient.com/dbilogos
>
> Thats all the time I have to play with this,
> but if anyone feels a need to burn up their
> day, c
I should say, that I am running oracle under linux emulation on FreeBSD.
I have 5.6.1 Linux Perl running. Like I said before the DBD::Oracle
1.12 compiles fine.
Here are where the header files are,
/usr/compat/linux/usr/include/bits/posix1_lim.h
/usr/compat/linux/usr/include/bits/posix2_lim.h
I can't even get 1.15 to compile w/ 8.0.5,
cc -c -I/usr/oracle/rdbms/demo -I/usr/oracle/rdbms/public
-I/usr/oracle/plsql/public -I/usr/oracle/network/public
-I/usr/oracle/rdbms/demo -I/usr/oracle/precomp/public
-I/usr/oracle/rdbms/demo
-I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
-I/usr/lo
I captured the output from 'perl Makefile.PL' for 1.12 & 1.15. I did
a diff of the two, I cannot see much difference (unless I'm just not s
seeing it).
On Thu, 2004-07-08 at 14:36, Scott T. Hildreth wrote:
> I can't even get 1.15 to compile w/ 8.0.5,
>
> cc -
Was your DBD::Oracle compiled against 8i libraries? If so you can
connect to the 9i by using sqlnet,
i.e.
my $dbh = DBI->connect('dbi:Oracle:${9i_Sid}'. $user, $passwd, {});
Or recompile DBD::Oracle using the 9i libraries.
On Tue, 2004-06-29 at 03:02, Nayana hanji wrote:
> Hi,
>
> When
On Wed, 2004-05-12 at 10:48, JupiterHost.Net wrote:
> Thanks for all the replies! Its much clearer now :)
>
> Just to clear up the qw() issue, I included quotes so that the data
> would be quote()ed for the query, not sure if that was necessary or not
> since do() didn't do quote()...
>
> IE I
no, the @bind_values is a list to bound for that statement. It could 1
or many (i.e. if you have where id = ? and date = ? ). If you have a
list of values that need to be inserted into different rows, then
iterate through the array and execute the 'do'. A word of caution, if
the list is going to
Mon, 2004-05-10 at 14:33, Scott T. Hildreth wrote:
> I guess it would depend on which database you are using. I would try
> it with a bind column and let the DBD driver handle the quoting if need
> be,
>
> $dbh->do(q{
> update mystuff set binaryfld=?
> Whe
..forgot to cc list.
On Mon, 2004-05-10 at 14:33, Scott T. Hildreth wrote:
> I guess it would depend on which database you are using. I would try
> it with a bind column and let the DBD driver handle the quoting if need
> be,
>
> $dbh->do(q{
> update mystuff set binary
How about using a convenience method,
$nm = $dbh->selectrow_array(q[select global_name from global_name]);
print "\nThe instance is $nm\n" if $nm;
On Fri, 2004-04-30 at 05:47, Srikanth Madani wrote:
> TMTOWTDI and all that :-) - but please do correct me if this code is
> inappropriate in some w
On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote:
> Tim,
>
> What performance problems are you having exactly? Did you run a 10046 trace? Are
> you passing the {ora_check_sql => 0} in your prepare() call?
>
> Also, I would suggest you look into SQL*Loader. Nothing you ever write in Perl will
>
nvironment variables
in a persistent state.
Can anyone give me a hint?
Thanks,
Scott
Thanks for the PerlMonks suggestion. I found a solution out there.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Ronald Kimball [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 12:51 PM
To: NIPP
appreciated.
symlink("$loc[($push -1)]/bin","/tlgld/bin")
I am wondering if there is a problem with the variable expansion or
something. Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Jeff Zucker wrote:
>>>t/coredubious
>>>
>>Not one response since Feb 9th? what's going on here?
>>
> You mean the Feb. 9th that happend less than two weeks ago? Did you
> submit a patch? If not, what is going on is probably that the module's
> author a) has a life and/or b) is busy. :-)
Scott R. Godin wrote:
> t/coredubious
> Test returned status 0 (wstat 139, 0x8b)
> Scalar found where operator expected at (eval 153) line 1, near "'int'
> $__val"
> (Missing operator before $__val?)
> after all the su
my attempted build. Any insight
> would be much appreciated.
>
> Thank you,
>
> Scot Greisch
> Internet/Web Administrator
> Thousand Trails/NACO/Leisure Time, Inc.
> [EMAIL PROTECTED]
> http://www.1000trails.com
>
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 17-Feb-2004
Time: 17:39:14
--
>
>
> Thank you for your time and assistance in this matter.
>
> Regards,
>
> Michael Grey
>
>
> __
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
>
> - End forwarded message -
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 15-Feb-2004
Time: 07:51:07
--
cpan> test DBI::Shell
Running test for module DBI::Shell
Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Fetching with LWP:
http://cpan.develooper.com/authors/id/T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Fetching with LWP:
http://cpan.develooper.com/authors/id/T/TL/TLOWERY/CHECKSUMS
Checksum for
build log is attached, looks like libclntsh is linked in.
On Fri, 2004-01-30 at 04:22, Tim Bunce wrote:
> On Thu, Jan 29, 2004 at 02:07:49PM -0600, Scott T. Hildreth wrote:
> > I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7.
> > 1.14 builds(make test), but 1.15
96969187424 | T |
0008
searching oracle lib/libocijdbc8_g.so ...
OCILobWriteAppend| 0004396962439648 | T |
0008
My LD_LIBRARY_PATH is set(same setting as when I compiled 1.14).
Here is output of 'perl Makefile.PL -s OCILob
On Thu, 2004-01-29 at 14:07, Sco
101 - 200 of 429 matches
Mail list logo
