Dear DBI users,
This is to announce yet another wrapper module on top of DBI, just posted
on CPAN. Please have a look and see whether it can help suit your needs.
The discussion forum is on http://www.cpanforum.com/.
Below is an excerpt from the doc :
DBIx::DataModel is written compactly as one
C.A. Merz
- Original Message -
From: PerlDiscuss - Perl Newsgroups and mailing lists
[EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, April 26, 2005 12:54 PM
Subject: DBD::Oracle Installation problem
Hi,
When I install DBD::Oracle module, I get the following error
Hi,
When I install DBD::Oracle module, I get the following error.
=
ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class:
ELFCLASS64
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
collect2: ld returned 1
Hi all who help others,
i would like to create a database handle to informix
database on alpha maschine.
what do i have:
# uname -a
OSF1 trm61 V4.0 878 alpha
# /usr/informix/bin/tbstat -z
RSAM Version 5.08.UD2 -- On-Line -- Up 07:53:56 -- 9968 Kbytes
#
i wrote a perl-script which works
Hi all who help others,
i would like to create a database handle to informix
database on alpha maschine.
what do i have:
# uname -a
OSF1 trm61 V4.0 878 alpha
# /usr/informix/bin/tbstat -z
RSAM Version 5.08.UD2 -- On-Line -- Up 07:53:56 -- 9968 Kbytes
#
i wrote a perl-script which works
If the string passed to Access has a number at the end no records are
returned.
If I remove the number and there are records in the file that match the
remaining characters then records are returned.
I can go into Access and use the same string and the search works.
Any help would be greatly
Hello,
I am sure this question has come up hundreds of times, but I must ask
it again:
Are bind_param_array() and array_execute() fully implemented in the
DBD::Oracle driver??
If they are, is there any known reference/examples of usage beyond the
DBD/DBI docs??
For the life of me, I cannot
Hi David,
I coded the connection stuff a little different. I too was having
timeouts thrown back when the result sets were large. The same query
would take almost three minutes in a query window. So I set the
CommandTimeout to zero as described in the cpan doc. Looks like this for
me:
Hi John,
U dont define $ORACLE_HOME in the connection string.
Either you define it in httpd.conf using SetEnv, or if in a
perl section using PerlSetEnv or even $ORACLE_HOME = '/your/oracle/home'
in your startup script in a BEGIN block.
Thanks
Raj
John wrote:
Well, how could i define the
I am trying to run an MS SQL server stored procedure using Perl.
We are using SQL Server 2000. Using the current Perl and DBI.
Can I use the ODBC DBD?
I am using a prepare,execute and fetch.
Has anyone tried this and do you have examples or how to do this?
I use the 'exec' command but get syntax
Hi
You cannot use the DESCRIBE statement as it is. Try it in the following way
select * from sys.user_tab_columns where table_name = 'TABLE_NAME';
Cheers
Prabu
Jimmy Jauhal wrote:
Hi All,
I am trying to execute a DESCRIBE table statement from my perl script that
connects to an oracle
Hello.
I have a perl module that uses DBI and works when executed from shell.
When its run from Apache I get gibberish error on connect.
I have narrowed down that somehow my debian system had two installations
of postgresql - one compiled and one via apt-get. The compiled psql in
Platform: Windows XP Pro
oDBC Driver Manager: included in windows
backend database: MS Access 2000
Perl version: 5.8.3
Apache version: 2.0.48
DBI version: 1.42
DBD::oDBc version 1.09
MDAC version: 2.8
lil newbie here requiring help. im trying to upgrade from windows to open
source and am
Hello dbi users,
I'm using DBD Oracle with ORACLE 8.1.7 on HP-UX Cluster with 2 nodes on
failover mode.
There is 2 ou 3 databases running on same time (8.1.7) but the ORACLE_HOME
used to compile DBD-Oracle may not be mounted.
So, I make chatr +s on Oracle.sl library to enable use of SHLIB_PATH
Hello dbi users,
I'm using DBD Oracle with ORACLE 8.1.7 on HP-UX Cluster with 2 nodes on
failover mode.
There is 2 ou 3 databases running on same time (8.1.7) but the ORACLE_HOME
used to compile DBD-Oracle may not be mounted.
So, I make chatr +s on Oracle.sl library to enable use of SHLIB_PATH
I sm trying to install Msql-modules-0.91 I need this module because i
have many scripts that use use Msql; and don't want to
install DBI::msql because I will have to rewrite code to 1000 scripts. I
am on a suse 9.1 with perl 5.8.3 The error I get after unpacking and
running make:
cc -c
I have a question along this line.
I have:
Windows NT which has MS Access with ODBC driver.
Linux w/Apache2 and am trying to write Perl cgi.
What I want to do is, User enter CustomerID at web page, then CGI will
query customer info using ODBC and display the info to user.
I found DBI::Proxy
Hi,
Can you tell me why
Insert into Foo values (?, EMPTY_BLOB()) returning data into ?
causes a segmentation fault.
Where Foo is create table Foo (id integer, data blob);
The section of the code that runs this sql statement is
$stmt = INSERT INTO Foo VALUES (?, EMPTY_BLOB()) returning the_file
I am not sure if it makes a lot of difference, but my perl version is:
[opt]$ perl -v
This is perl, v5.6.1 built for i386-linux
But: DBI-1.41 Makefile uses $] to guess the perl version, and that gives a
lower version:
[opt]$ perl -e 'print $]\n'
5.006001
Will this have consequences for
When I run make test for my module, I get error code 29 - Command failed
for target 'test_dynamic'.
Here is the test output:
# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/base...
t/base...ok
I am getting this error:
ORACLE_HOME environment variable must be set
but when I type:
echo $ORACLE_HOME
I get:
/opt/oracle/product/9.2.0
Seems the ORACLE_HOME is set.
I have Oracle 9i R2 installed on Redhat9
Can anyone help with this error?
21 matches
Mail list logo