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
Hi,
I'm migrating a perl application in postgres to Oracle. Here, the data is
being retrieved as below.
while ($row = $sth->fetchrow_hashref()) {
push (@list,$row);
}
It looks like fetchrow_hashref() is not working with Oracle. But I'm able
to retrieve the data through fetchrow_array.
> Landeshauptstadt München
> Direktorium - AFID 3.3 - Oracle DBA
> C.A. Merz
> ----- Original Message -
> From: "PerlDiscuss - Perl Newsgroups and mailing lists"
> <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, April 26, 2005 12:54 PM
> Subject:
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 exi
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 fin
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 fin
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 app
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:
i
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 $ORACL
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 er
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 = '';
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 DB. For s
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
/usr/local/pgsql/
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 install
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 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 and
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/usr/l
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
Hello,
I'd like to get some feedback on a new module in the DBIx hierarchy. It
is another DBI wrapper, or a lightweight object-relational mapping if you
prefer to look at it that way. The main goal is ease of writing a simple
database app. I have a lot of the code ready and working, it doesn't
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 build
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
t/curso
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?
23 matches
Mail list logo
