On 06/22/2005 04:06 AM, Vamsi_Doddapaneni said:
I have a doubt regarding the usage of export.pm.
This is not a DBI question, you would be better off asking on a general
Perl forum.
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter:
On 06/19/2005 10:24 PM, prashanth said:
i would like to know the detailed architecture and design of dbi. i would
like to know how its been written and how it interacts with the drivers etc.
i would like to know whats going on internally... any pointers to this would
be appreciated. thanks in
On 06/20/2005 04:24 AM, vasundhar said:
On 6/20/05, Clive Eisen [EMAIL PROTECTED] wrote:
You want us to do your homework?
For collective learning if we are asked to do so ... We must be ready
Then read the fine manual with the URL I gave you before:
On 06/16/2005 02:55 AM, Ashish Jain said:
I am using Oraperl pack for my development. I get the following error at
the line where I use Oraperl ( use Oraperl).
You should not be using Oraperl for new development. It is a wrapper
around DBI and DBD::Oracle intended to allow existing programs
On 06/14/2005 04:58 PM, McLean, Emmett (HQP) said:
Hi,
Opon attemping a DBD::Oracle install it appears that I must install OCI
first to get oci.h ...
But if I attempt to install OCI first it baulks that it can't find
Oracle.pm
Any suggestions?
Here is the DBD::Oracle install attempt :
On 06/13/2005 05:39 AM, Shailesh Mali said:
I am trying to install DBI and DBD modules on Solaris 10
and getting following error. Please suggest is there any solution for
this problem.
Perl.xsc mv Perl.xsc Perl.c
cc -c-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8
-D_TS_ERRNO -xO3
On 06/13/2005 02:56 AM, Avis, Ed said:
Michael A Chase wrote:
Placeholders are VARCHAR2 by default. If you know what columns you
are inserting into (and you should), you can use
$dbh-column_info() to find out the column types.
Sorry, I gave the wrong example. In fact my query is just
On 06/13/2005 06:28 AM, Avis, Ed said:
Michael A Chase wrote:
Ed said:
I'd like to find out whether Oracle is expecting a given bind
variable to be a datetime, an integer or whatever.
The original example may have been wrong, but the advice still
stands. You can control the type of each
Quoting Avis, Ed [EMAIL PROTECTED]:
Michael A Chase wrote:
All placeholders are VARCHAR unless the type is explicitly given in the
bind_param*() call.
I'm not quite sure what you mean. It is quite possible for a
placeholder to be of DATETIME type, for example. Perl passes the
date
Quoting Denesa K Shaw [EMAIL PROTECTED]:
How does a script handle when null values are returned from a stored
procedure?
The same as any other NULL values.
http://search.cpan.org/~timb/DBI/DBI.pm#Notation_and_Conventions
But you are asking the wrong question. You want to know when the
Quoting Avis, Ed [EMAIL PROTECTED]:
Is there a way I can prepare a statement handle for some SQL like
insert into some_table values (:a, :b)
and then find out what types the database is expecting for the two
placeholders? I'm using DBD::Oracle.
Really I just want to know whether a
On 06/06/2005 02:06 PM, Peter Rabbitson said:
On Mon, Jun 06, 2005 at 01:11:30PM -0700, Vergara, Michael (TEM) wrote:
I want to connect to an Oracle database and test for the existence of
a table. My first thought was to SELECT COUNT(*) FROM TABLE, but
DBI catches the ORA-942 error and I
Quoting David Goodman [EMAIL PROTECTED]:
As I understand it, I have choices of:
--building under cygwin, which then requires me to run under cygwin.
Cygwin also tends to be a bit slow. That may or may not matter in
your target environment. On the other hand, it gets you the
closest to a
On 06/01/2005 04:33 AM, Malka Cymbalista said:
Thanks to everyone who tried to help. In the end I solved the
problem by searching on google and finding the answer. The problem
is specific to mod_perl2 which is what we are running. I'm not sure I
really understood the explanation but it has to
On 05/25/2005 04:46 AM, Malka Cymbalista said:
Our web server is running Apache 2.0.48 with mod_perl 1.99_12 on a Sun
machine running Solaris 9. We are running perl 5.8.1, DBI 1.39 and
DBD-Oracle 1.16. We are trying to connect from our web server to an
Oracle database that is on a different
On 05/24/2005 06:40 AM, shanthi nagarajan said:
Dear Friend, I am shnathi Nagarajan working as a computer operator in
Bioinformatics centre, Pondicherry University, India. Presently I am
trying to connect perl and mysql. I have downloaded DBI-1.25.tar
module and extracted into
On 05/13/2005 11:01 AM, Denesa K Shaw said:
How do I pass the value of the variable $FILE_NM returned
in the subroutine get_file to the subroutine
Update_T_Received? I'm needing this value to for my update
statement.
Normally I can easily return the string from a sub routinge,
then call it from
On 05/12/2005 04:50 AM, Rachel Llorenna said:
Use SHOW COLUMNS on the table first; check if the desired column name
is in there, or ALTER TABLE as necessary. I think there is a
MySQL-specific command you can probably use; IF NOT .. clause, but
that's bad practise. It's probably better to use
On 05/10/2005 07:10 AM, Mohankumar said:
I am using the Perl version 5.005_02, DBD::ASAny::VERSION = '1.12'
and ASA 9.0.0.
Fetching BIGINT failed when they contained more than 8 digits. I have
a workaround by converting the BIGINT to VARCHAR using convert(). But
this conversion is not possible for
On 05/09/2005 12:45 PM, Robert said:
I am pulling data out of Oracle and putting it into an Excel spreadsheet.
Using this:
while ( $row = $sth-fetchrow_arrayref ) {
# this is a fast and simple way to deal with nulls:
foreach (@$row) { $_ = '' unless defined }
push (@results, @$row);
On 05/09/2005 03:47 PM, De Joe, Jackie said:
I have two questions, first do I understand correctly to use DBD::TSM 1.48
I must have DBI installed?
You understand correctly.
Second, I am having trouble installing DBI. Here's some info: I am very
much a newbie at compiling code, any help will be
: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 01, 2005 6:00 AM
To: Saiyed, Khatir
Cc: dbi-users@perl.org
Subject: Re: Build dbd::oracle for both Oracle 8.x And Oracle 9.x
...
DBD::Oracle is built for a particular API, Oracle 8.1.7 or 9.2.0 in your
case, and you must have ORACLE_HOME
On 05/03/2005 11:42 AM, [EMAIL PROTECTED] said:
/usr/ucb/cc: language optional software package not installed
*** Error code 1
make: Fatal error: Command failed for target `Perl.o'
What language optional software package (name) does the error message
refer to?
The one that includes the same
On 05/04/2005 02:40 PM, Denesa K Shaw said:
Any Ideas on why I'm getting this error? It appears not to like my date
that I'm passing to it. I printed the date to a log and it looks ok, any
ideas?
Error:
DBI::st=HASH(0x20391b00)-bind_param(...): attribute parameter
'TO_DATE('01/02/200','mm/dd/
On 04/30/2005 10:33 PM, Saiyed, Khatir said:
Can I build single dbd::oracle to work with both Oracle 8.1.7 and
Oracle 9.2.0 running on the Server (Solaris 8) ? If yes, how ? If
not, any other better means to acheive this.
DBD::Oracle is built for a particular API, Oracle 8.1.7 or 9.2.0 in your
On 04/27/2005 01:22 PM, Chekuri, Lalitha said:
It is fresh install:
magma:oracle $uname -a
SunOS magma 5.9 Generic_117171-12 sun4u sparc SUNW,Ultra-60
My perl -v
magma:oracle $perl -v
This is perl, v5.6.1 built for sun4-solaris-64int
(with 48 registered patches, see perl -V for more detail)
For
On 04/28/2005 05:32 AM, Job Miller said:
After a little searching of archives, I found the same exact problem
and the same self-proposed workaround almost a year ago. Is there a
better way without creating another column in a temp table? I
couldn't find a follow-up to this post.
There is an
On 04/28/2005 06:54 AM, Chekuri, Lalitha said:
My problem is:
To install perl it is asking cc
I downloaded gcc from freeware,
To install gcc: if I have cc in path it is giving /usr/ucb/cc:
language optional software package not installed error.
If I don't have cc in the path it is saying cc not
On 04/26/2005 03:39 PM, Wang, Weili said:
I have downloaded DBD-Oracle DBD-Oracle9-1.16-5.8.4.tar.gz from
ftp.esoftmatic.com ftp://ftp.esoftmatic.com/ website and unzipped it.
Could you tell me how to install DBD-Oracle on Windows 2000 system?
Did you read the instructions in
On 04/27/2005 03:01 AM, Charles Jardine said:
Here is a patch to the pod documentation of DBD::Oracle-1.16.
The patch alters the section headed 'Binding Cursors'.
diff -ur DBD-Oracle-1.16.cursor-docs/Oracle.pm DBD-Oracle-1.16/Oracle.pm
Your diff has the source files reversed.
Thank you for the
On 04/27/2005 01:13 PM, Reidy, Ron said:
b. Install gcc properly (**AND** you will need to downgrade from the
3.x version to 2.96 as described in the Oracle installation manuals)
Where did you see this? The advice is several years out of date. I've
used a couple different gcc 3.x versions to
On 04/26/2005 03:54 AM, PerlDiscuss - Perl Newsgroups and mailing lists
said:
When I install DBD::Oracle module, I get the following error.
=
ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class:
ELFCLASS64
...
Summary of
On 04/23/2005 08:30 AM, RKris said:
Hi, I am getting data corruption when I attempt to run
several processes in parallel when making changes to
two tables.
DBD version 1.16, DBI version 1.48, Linux 2.6, Oracle 9i.
I am trying to select a counter value from table 1,
insert it into table 2 and
On 04/21/2005 09:16 PM, [EMAIL PROTECTED] said:
Thanks for the reply. Can u give me link for downloading the perl oracle
dbd driver for WINDOWS XP operating system.I cannot ftp in my place so i
like to get it from any http site.Before installing the new one i need to uninstall
the already
On 04/22/2005 09:30 AM, Denesa K Shaw said:
How do I pass an one parameter to a External Stored Procedure?
I don't think anyone here has a clue. Without knowing what DBD driver
you are using, the answer would be pure guesswork. Please read the URL
in my signature.
If you have a DBI 1.38 or
On 04/21/2005 06:46 AM, [EMAIL PROTECTED] said:
I am facing poblem in connecting a database thru perl program
Here are the details about the packages which i installed in my Windows
machine
...
ppm describe dbd-oracle
===
Name:
On 04/21/2005 10:11 AM, Robert said:
This was a solution:
my $insert_stmt = Insert into TABLE (name, date, type, federal, active)
values( :name, :date, :type, :federal, :active );
my $sth = $dbh-prepare( $insert_stmt );
my $holidays;
foreach my $name ( keys %holidays ) {
$sth-bind_param(
On 04/19/2005 10:18 AM, Hemanth Kumar said:
I am trying to install DBD 1.3 with DBI 1.37 on Solaris and the database
version is Oracle 9.2.
When I run the make command it returns the following error:
In file included from Oracle.h:20,
from Oracle.xs:1:
dbdimp.h:44: ocidfn.h: No
On 04/19/2005 10:42 AM, Ian Harisay said:
I am having problem with spaces. I am loading data from a normalized
schema into a denormalized table. Many of the fields I am copying
originally come from free form fields and we don't attempt to clean
them up at all. What we grab in the form is what
On 04/18/2005 10:49 AM, Mike Scott said:
I'm using DBI and DBD::Oracle.
I'd like to be able to describe a table, but 'describe table' fails no
matter how I try to pass it to DBI.
I feel certain that this is a FAQ and so apologise in advance. I have
tried to track down an answer, but describe
Quoting Vamsi_Doddapaneni [EMAIL PROTECTED]:
I am new to perl just (1 1/2 month experience.). I am developing perl script
which connects to oracle database and selects rows from a (x) table and then
inserts them into its corresponding table in db2. So, while inserting i need
to find what is
On 04/07/2005 04:05 AM, xaver biton said:
i've 2 select query. the first one is like
my $sql = $dbh-prepare(q{select * from test});
If all you want is col4, it would be safer to use SELECT col4
the second:
my $sql1 = $dbh-prepare(q{select * from test1 where test1.row = ?})
$sql-execute();
On 03/26/2005 04:12 PM, Jesus Altuve said:
I was wondering if it is possible to use mysqlhotcopy to use rsync
instead of cp in order to make an incremental backup of a database.
cp is the only copy method supported, but if you included the 'only
method supported' statement it is because you were
On 03/24/2005 05:31 PM, Gav said:
Can someone point me as to what is wrong with this :-
#!/usr/bin/perl
use CGI::Carp qw(fatalsToBrowser);
use CGI qw(:standard);
use DBI;
$|=1;
On 03/21/2005 12:34 PM, Simon Windsor said:
I am having problems accessing postgres from mod-perl on one box. The
error I am getting is
install_driver(Pg) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/auto/DBD/Pg/Pg.so' for module DBD::Pg: libpq.so.3: failed to map
On 03/19/2005 06:44 AM, John said:
Has anyone tried to install DBD::Oracle with success while Oracle
Client is installed?
In my case oci.h and some other headers were not found and i
ultimately enforced to install the whole database server for the job.
Is there any known trick about that?
Oracle
Please do *not* start a new question by replying to an old one as
this causes several problems:
1) most email software will correctly think that your email is a
response to the email you are replying to, and will indicate this
by displaying your email as a child of the original email
2) because of
On 03/16/2005 08:25 AM, Charles Jardine said:
perldoc DBD::Oracle says, under Binding Cursors:
To close the cursor you (currently) need to do this:
$sth3 = $dbh-prepare(BEGIN CLOSE :cursor; END;);
$sth3-bind_param_inout(:cursor, \$sth2, 0, { ora_type =
ORA_RSET } );
$sth3-execute;
This
On 03/16/2005 09:50 AM, NIPP, SCOTT V (SBCSI) said:
Still banging my head into a wall... Now I am getting NULLs
inserted as expected into the database, but I am getting errors on the
compare.
my @old = $test-fetchrow_array ();
foreach $n (0..20) {
chomp($file_val =
Quoting Moreno, Javier [EMAIL PROTECTED]:
Actually it is now getting worse. It has AutoCommit set to 0 so I am doing
this:
$::sql = UPDATE GLOBALSettings SET Lang = ?;
$::crt = $::lang_code;
Debug(About to prepare: $::sql with criteria: $::crt);
$::sth = $::dbh-prepare($::sql) or
On 03/10/2005 01:52 PM, Graeme St. Clair said:
I just tripped over a curious thing. It turned out that my d-b contained
the occasional column with accidental leading blanks. I altered the query
to:-
SELECT TRIM(LEADING ' ' FROM CUST_NAME) AS CN, COUNT(*) AS C FROM DB GROUP
BY CN ORDER BY CN
On 03/09/2005 01:02 PM, James B Schmidt said:
Please remove me from the list.
List-Help: mailto:[EMAIL PROTECTED]
List-Unsubscribe: mailto:[EMAIL PROTECTED]
If you are sending the unsubscription request from a different email
account than the one being sent to (see Return-Path and Received in the
Quoting edward pena [EMAIL PROTECTED]:
Actually, that does not work consistently.
The most common cause for it to not work is mentioned in the last paragraph of
the document extract below. Many Oracle instances are set up to refuse remote
connections as DBA or OPER.
-Original
Quoting Moreno, Javier [EMAIL PROTECTED]:
This is probably a dumb question, but how do I run stored procedures with
the DBI? I am using DBD::ODBC.
It's pretty low level, but you may find some of the links in the perldoc useful.
http://search.cpan.org/~jurl/DBD-ODBC/ODBC.pm
A Google search
On 02/24/2005 02:21 AM, davinder kohli said:
I am having Perl 5.8 version and Oracle 10g installed on Windows
server 2003. I am able to connect as well as execute Oracle queries
from the command line. But wfrom the browser I am not able to connect
to ORACLE database. Please help me.
Thanks in
On 02/24/2005 08:08 AM, susan lam said:
I'm new to perl. I apologize if this is not the right
place to post newbie questions.
This is the right forum for DBI and DBD questions.
If mytable does not exist, I would like to trap the
Oracle error message and write the message to an
Oracle table. I
On 02/21/2005 02:23 PM, Jeff Zucker said:
$dbh-do(CREATE FUNCTION foo);
# pre-declares function foo, a perl subroutine in current package
$dbh-do(CREATE FUNCTION foo AS Bar::baz);
# pre-declares function foo, using baz, a subroutine in package Bar
Since AS usually introduces an alias, this
On 02/19/2005 02:25 PM, xaver biton said:
wht's wrong with the following code, I should recieve
'49201','49203',
'49','49203',
'49203','49203'
and if I don't use the sub I do that, but if I use the sub I recieve only
'491'
To make sure I understand, if you take the guts out of area() and run
that
It's nice that everyone is so helpful with the CGI problem, but this isn't a CGI
list. DBI comments below.
Quoting MCMULLIN, NANCY [EMAIL PROTECTED]:
($pnotes) = $dbh-selectrow_array(SELECT notes FROM table WHERE t1 =
'$pt');
On 02/18/2005 02:33 PM, Douglas Greenwalt said:
What DBD version of Oracle is the most current and where do I get it?
Currently put on DBI/5.8.3/DBD-Oracle.ppd from esoftmatic.com.
If you're running ActivePerl in MSWin and not ready to buuild it
yourself, esoftmatic.com is the best source.
On 02/14/2005 11:10 AM, [EMAIL PROTECTED] said:
If I don't use strict, I get the following errors:
You should (nearly) always use 'use strict;'. It helps prevent single
errors from combining into real rats' nests.
Database error: DBI::st=HASH(0x239094)-bind_param(...): attribute
parameter
Quoting David Goodman [EMAIL PROTECTED]:
Hello Michael:
You write:
Theoretically yes - at least for queries (select
statements). Print and raiserror statements *should*
normally be sent back in the same way as you'd get
them in isql, but you may be seeing buffering
differences where the
On 02/04/2005 10:38 PM, Jeff Macdonald said:
It seems it is no longer included, and scanning the Changelogs doesn't
give me a clue why. Is there a better alternative?
http://search.cpan.org/~tlowery/DBI-Shell/
From DBI/Changes:
=head2 Changes in DBI 1.34,28th February 2003
...
Removed old
Quoting Adam Stoller [EMAIL PROTECTED]:
On Feb 3, 2005, at 1:45 PM, Adam Stoller wrote:
For the record - incompatible in this case apparently means that we
had a 64-bit version of the library (client installation) on the
machine where everything else was 32-bit (gcc, perl, etc.) - and has
On 01/28/2005 03:55 AM, Ing. Branislav Gerzo said:
Hi all!
I have subroutine, that checks, if I already have in DB specified row:
sub image_exist {
my ($id, $date) = @_; #id is _always_ number
my $sth = $mydbh-prepare_cached(select ID from pic where id = ?);
$sth-execute($id);
my
Quoting Thomas L Shinnick [EMAIL PROTECTED]:
At 09:26 1/28/2005, Peter J. Holzer wrote:
I just read a Debian advisory about CAN-2005-0077,
A link would have been nice...
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CAN-2005-0077 says under
review
On 01/28/2005 12:51 AM, sudheer raghav said:
when am running this program with command perl
dh.pl it is working fine.But whenever i run it on web
browser it is not retrieving records from database.
This is not a DBI issue.
Go to http://search.cpan.org/~adesc/DBI-FAQ/FAQ.pm then search for 4.4
On 01/25/2005 01:29 AM, Waghmare, Satish (IE03x) said:
Please help me to know how to I download the DBI packages from FTP site. I'm
using ActiveState ActivePerl 5.8 on Win-XP system.
Please see below Error log:
C:\Documents and Settings\SatishWppm install
On 01/21/2005 06:59 AM, sudheer raghav said:
am new to perl.
how to connect postgresql database to perl.
I replied to an identical message from you dated 01/17/2005 11:43 PM with:
=
Please look at http://www.catb.org/~esr/faqs/smart-questions.html .
For DBI,
Quoting Chad Terry [EMAIL PROTECTED]:
Having the notorious problem where trailing spaces are being truncated
from bind variables. I have found two solutions, one is to rtrim the
column in the SQL statement, the other is to set the type to CHAR with
bind_param. The problem is, I will be
On 01/19/2005 05:01 PM, Nina Markova said:
I found solution myself reading information from the google group. I
should autocomit off. I did it and works.
Thank you for the followup with the solution you found. It may be
useful to someone else later.
--
Mac :})
** I usually forward private
On 01/17/2005 11:43 PM, sudheer raghav said:
Please look at http://www.catb.org/~esr/faqs/smart-questions.html .
For DBI,
http://search.cpan.org/~timb/DBI/DBI.pm
http://search.cpan.org/~timb/DBI/
http://search.cpan.org/~timb/DBI/lib/DBI/FAQ.pm
For DBD::Pg,
On 01/17/2005 05:02 AM, Waghmare, Satish (IE03x) said:
Send me the PPM package for DBD::Oracle.Activestate 5.8
http://ftp.esoftmatic.com/DBI/
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give
On 01/17/2005 12:04 PM, Moreno, Javier said:
Does anyone know of a repository where I can find DBD::Oracle? I have
tried the ActiveState default repository but it reports it is not
available.
It would be worthwhile for you to read the responses sent to you before
you ask the same question again.
On 01/12/2005 06:39 AM, [EMAIL PROTECTED] said:
I have a Redhat box with 2 ORACLE_HOMEs. DBI and DBD_Oracle have
both been installed.
How can I tell which ORACLE_HOME was used to build the DBD?
Call oraenv for each environment and try connecting to a database
through each. If one fails, don't
On 01/10/2005 04:32 PM, Jacob Salomon said:
I have no trouble building perl 5.8.0 and the DBI 1.4.6 module on a
development system with a compiler (and having just untarred into a virgin
directory). I wish to create a TAR-able image so I can also install it on a
box with no compiler. Following
On 01/11/2005 07:26 AM, ruimvelds said:
I have inherited a Unix box with solaris 5.7 and Perl 5.6.0
installed. It was created in 2001.
I have had problems accessing an Oracle 9i database. One
recomendation was to install the 9i client on the box, but the 9i
client software only has
On 01/09/2005 09:00 AM, Reidy, Ron said:
The error message says it all. You need to set (at a miniumu) ORACLE_HOME and
ORACLE_SID.
Read all the README* files in the DBD::Oracle distribution.
There's a reason that the standard install sequence for Perl modules
includes `make test`. That should
On 01/05/2005 11:33 PM, Sam Vilain said:
Thilo Planz wrote:
The Oracle 10g client libraries used by your DBI should be able to
connect to older versions of Oracle as well. So ideally, your
8.1.7 users can use the DBI you already installed.
Careful, there's a compatibility matrix there. I vaguely
This discussion belongs on the DBI users list (dbi-users@perl.org), so
I'm sending this response there instead of to oracle-oci.
On Tuesday 04 January 2005 09:47, Sandeep Warikoo wrote:
I'm trying the access oracle through perl, but am getting the error
ERROR OCIEnvInit.
My perl script is:
On 01/04/2005 10:31 AM, Boris Volf said:
I tried installing DBD-Oracle using ppm, and was unsuccessful.
Then I downloaded this module from CPAN, and copied Oracle.pm into
C:\Perl\lib, but I am still getting the same error.,
Naturally you are still getting the error, just copying Oracle.pm to
On 12/29/2004 08:05 AM, Bender Eliyahu-Yosef-BEB067 said:
I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote
ppm and then install DBI. The respond I got was :
Error : No Valid repositories: Error : 500 Can't connect to
ppm.Activestate.com:80 Bad hostname 'ppm.ActiveState.com'
On 12/29/2004 10:56 AM, Maldonado, Daniel CW2 CTARNG said:
Hi there again, this may not be the best forum to ask this question but I
don't think there is a DBD::Oracle list available.
This is the right place. The DBI list is a good first stop for all DBI
and DBD user issues.
Does anyone have a
On 12/23/2004 07:55 PM, Tony McCray said:
Thanks Dave, you helped a lot actually. It turns out that I have a
file in /lib called libnss_files.so.2. I made a copy of the file and
got rid of the '.2' extension. I had to do the same thing with
libnss_dns.so. I haven't tested it yet, but make, make
On 12/23/2004 12:15 PM, Peter Barnett said:
We have a new DBD install that is giving us trouble.
The perl files are linked from a directory
/obase/tools/perl/perl to /usr/bin/perl. The DBD is
installed in the /obase/tools/perl/dbd directory.
Not much to go on but the developers are very new to
On 12/20/2004 11:57 AM, Teddy Choi said:
Could you please let me know what the status is on the availability of
Oracle::OCI ?
It isn't in CPAN yet, and I haven't been able to google up a beta version.
The version on CPAN is a bit old, or is that stable?
http://search.cpan.org/dist/Oracle-OCI/
--
On 12/18/2004 07:55 PM, xaver biton said:
how do I use like as bind variables, eg:
select * from users where user.tel like '49755%'.
could xou make an example?
Note: users ne user.
http://search.cpan.org/dist/DBI/DBI.pm#Placeholders_and_Bind_Values
http://search.cpan.org/dist/DBI/DBI.pm#bind_param
On 12/18/2004 12:23 AM, govind tarcar said:
I am presently working on a project on CGi for my 7sem Cs course
Am unable to trace a DBI and DBD-ODBC packages for perl.
Tried some sources (ftp://ftp.esoftmatic.com/outgoing/DBI/DBI.ppd ) but
couldnt get it
Can u help me and send me the above
Suggested changes {before : after}.
On 12/16/2004 09:33 AM, CAMPBELL, BRIAN D (BRIAN) said:
Undefined values, or Cundef, are used to indicate NULL values.
You can insert {: or} update columns with a NULL value as you would a
non-NULL value. These examples insert and update the column
Cage with a
On 12/13/2004 06:09 AM, Hardy Merrill said:
I realize I'm splitting hairs here, and I'm no database expert, but I'm
curious about your answer to this - wouldn't this be even slightly more
efficient to write the WHERE clause conditions as most restricting
first? In other words,
SELECT
On 12/13/2004 09:33 AM, OIT said:
I am trying to save windump network trace files in MySQL. The following
piece works, and am able to insert into MySQL, but only a small piece of
this 50MB file is in there!!!
Is that a binary or text file? quote() is not likely to work correctly
on binary
Quoting dbsavvy2002-perl:
HERE IS THE CODE.CAN U PLEASE HELP ME WITH THIS. I
TRIED
%hasha= ();
@A=();
@A_F=();
TO UNINITIALIZE BUT STILL DONT WORK
#!/usr/bin/perl
use strict;
use Win32::ODBC;
my($db) = new Win32::ODBC('All Records1207');
my $keya;
my $ia=0;
my $ifa=0;
my @A;
my
Quoting dbsavvy2002-perl:
...
#!/usr/bin/perl
use strict;
use Win32::ODBC;
my($db) = new Win32::ODBC('All Records1207');
...
sub loopa
{
...
$db-Close();
...
}
loopa (4);
printhjgvjyg;
loopa (4);
While re-reading my original response, I noticed you are closing the database
object
On 11/26/2004 08:14 AM, Chris Holt said:
Thanks , I needed some one to tell me it was definately permissions.
It made me look harder at the perms on higher level directories. Now
I'll look at my connection problem .
Can't connect to data source exua, no database driver specified and
DBI_DSN env
On 11/25/2004 08:03 AM, Chris Holt said:
After being prepped by experiences of others in the README.aix
file. I beleive (see below), I have a good installation. But
on running my fist test prog I appear to have a permissions
problem. This litlle ditty does not fail when run as root,
but anyone
On 11/24/2004 05:07 AM, Hardy Merrill said:
Tim, can you elaborate a little? I've tried to find the referenced
documentation but can't. I don't quite understand how a CHAR datatype
can cause this problem.
CHAR column values are padded with spaces to the length of the column.
When compared with
On 11/24/2004 06:19 AM, Mark Martin said:
I have a very simple script to delete records from an Oracle table :
#!/usr/bin/perl
use DBI;
use DBD::Oracle;
$dbh = DBI-connect( dbi:Oracle:database, user, password) or die
Can't connect to Oracle database: $DBI::errstr\n;
$dbh-do( DELETE FROM TABLE
On 11/24/2004 04:55 AM, Steinhauer, Frank (CAM) said:
...
What actually happens is that the default binding for DBD::Oracle is
SQL_VARCHAR. When Oracle OCI sees that type, it automatically strips
trailing spaces leaving '' if that's all there was. Then '' is interpreted
as a NULL by Oracle.
Quoting nishikant uppal [EMAIL PROTECTED]:
can some one help me with this issue when iam trying
to install dbd-odbc 1.13 using makefile.the error i am
getting is
C:\DBD-ODBC-1.13perl makefile.pl
DBI object version 1.37 does not match $DBI::VERSION
1.46 at C:/Perl/lib/DynaLoa
der.pm line
Quoting Daniel Kasak [EMAIL PROTECTED]:
Michael A Chase wrote:
Quoting Daniel Kasak [EMAIL PROTECTED]:
I'm writing some code that needs to be able to figure out what DBD
driver is working with a current database *handle* ( so I can take
advantage of more advanced features of some drivers
1 - 100 of 848 matches
Mail list logo