Hi,
I know this may sound like a stupid question. Anyone
can give some hint regard Oracle PL/SQL + Perl
programming?
Any requirement that I need in order to successfully
use Perl to execute PL/SQL in Oracle?
Any site/REAME/doc that can share some insight into
this will be greatly appreciated.
Dear all
I am getting a problem on compilation DBI on solaris 8 on SPARC
and my gcc version is 3.0.3
Here is my error message :
# perl Makefile.PL
# make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBI
mkdir blib/lib/auto
mkdir blib/lib/auto/DBI
mkdir
Hello.
When I install the DBD-Oracle-1.12, I meet some problems with t/long.t when make
test, I meet such errors.
Unable to create test table for 'CLOB' data (3113). Tests skipped.
Unable to create test table for 'BLOB' data (3114). Tests skipped.
# failed test 141 at line 86. lob_locator
When you run perl Makefile.pl
this create automatically a Makefile in the current directory.
Could you show the content of this Makefile, please?
Jose.
-Original Message-
From: tied [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 februari 2002 9:30
To: [EMAIL PROTECTED]
Subject: Please help
-Forwarded Message-
From: Hans Scheffers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Compiling ODBC Drivers
Date: 20 Feb 2002 16:41:17 +0100
Hi,
I am trying to install the DBD-ODBC drivers, version 0.38 for sapDB.
SapDB has had a default install on RH 7.2
There are examples in the DBD::Oracle distribution. See
DBD-Oracle-1.12/Oracle.ex/ . There are also some in the fine manual
(perldoc DBD::Oracle).
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter:
Hello to all,
I am struggling with creating the prepared statement, passing to it a
placeholder param, and then executing in execute statement.
It seems not to be working. Can you please give me a suggestion/fix to my
problem.
Thanx a lot,
Daniel
PS: What am I doing wrong???
Oh. I use DBI
Please help in order to fix the problem, I am newbie
in the httpd.conf I have put the bellow lines:
Alias /perl/ /usr/apache/perl5/5.005/i86pc-solaris/Apache/
PerlModule DBI
When I try to run the httpd I get:
Can't locate object method trace_msg via package DBI at
Probably because nothing is returned. Try running the same query directly
in db, then see. Make sure you use the same where values, might want to
print them out to make sure they are what you expect.
No bind_params and execute(@params) is the same thing. execute calls
bind_params behind the
Why do you put that in httpd.conf? Are you using mod_perl? Are you sure.
You mean Apache::DBI?
Ilya
-Original Message-
From: Minas
To: [EMAIL PROTECTED]
Sent: 2/20/02 2:26 PM
Subject: Can't locate object method trace_msg via package DBI
Please help in order to fix the problem, I am
Hi all,
I was upgrading my DBD::ODBC from 0.28 to 0.38. The
tests seemed fine. But after make install none of my
scripts can connect anymore. I get this error:
[root@perseus installs]# testODBC.pl
DBI-connect(HOMER;DBN=devel) failed:
[unixODBC][Driver Manager]Data source name not found,
and
Here's an install session. I'm pretty sure that test
9 failing has nothing to do with the fact that I can't
log in anymore.
[root@perseus DBD-ODBC-0.38]# perl Makefile.PL
Configuring DBD::ODBC ...
Remember to actually *READ* the README file!
And re-read it if you have any
thank you oh so much
Hi dbi-users,
i got an error
sh: gcc: not found
*** Error code 1
make: Fatal error: Command failed for target `Perl.o'
when I execute make command on /export/home/dbadmin/perlmods/DBI-1.21
directory.
Can someone help me?
(See attached file: dbi_1.txt)
dbi_1.txt
Description: Binary data
Hello all...
I have a DBI call that returns a long list of names (10,000). I am
using fetchall_arrayref. The call seems to take up 40MB of memory. Is
this normal? Am I doing something wrong? Is there any special way to
free up this memory.
Hi,
Once, you have finish your fetch you'll need to free memory using :
$sth-finish();
It'll be better than nothing.
Moreover if your computer came down and frozen you have serious problem,
if i were you i'll shop some more RAM...
phinney wrote:
Hello all...
I have a DBI call that
I tried this test script in the ODBC package
(mytests):
[root@perseus mytest]# cat testdatasources.pl
use DBI;
print join(', ', DBI-data_sources(ODBC)), \n;
print $DBI::errstr;
print \n;
As you can see, it sees my datasources:
[root@perseus mytest]# perl testdatasources.pl
DBI:ODBC:demo,
Turn on tracing in the driver manager in odbcinst.ini
[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log
Have a look to see whats being passed to SQLDriverConnect and
SQLConnect, you may need a DSN= in front of the connect string.
Tim Harsch wrote:
Hi all,
I was upgrading my DBD::ODBC from 0.28 to
Nick,
Thanks. I don't have a odncinst.ini but if you meant
to do that in odbc.ini then I tried that.
it didn't produce a file.
--- Nick Gorham [EMAIL PROTECTED] wrote:
Turn on tracing in the driver manager in
odbcinst.ini
[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log
Have a look to see
Hi,
Hans Scheffers [EMAIL PROTECTED] wrote:
[snap]
Hi,
I am trying to install the DBD-ODBC drivers, version 0.38 for sapDB.
SapDB has had a default install on RH 7.2 using the rpm's (downloaded
from sap.org)
I have the TST database installed, and try to compile the ODBC driver
using
Hi all,
So I've used the Easysoft driver tracing and
determined that my simple connect script that fails
does find a odbc.ini file in home directory. I can't
read it well enough to determine what is causing the
failure.
The make tests for DBD::ODBC still work if I run them
with the 'make test'
Hi all,
Here's more info on the ODBC not connecting problem.
It doesn't seem to provide much insight, maybe you'll
have better luck though ...
-
Here's a DBI trace of a simple connect attempt:
DBI 1.21-nothread dispatch trace level set to 2
Note: perl is running without the
I just checked the Easysoft drivers with the test
programs they provide. I can successfully conect to
my database with it. So, it still seems to be a
DBD::ODBC issue.
__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
i think this has been asked before, just couldnt find a thread that had a
resolution.
so i have:
# perl /tmp/foo
DBI -- 1.20
Perl -- 5.00503
when im trying to make dbd oracle 1.12 im getting the lovely nbeq8
error...but if i dbd 1.06 compiles with no problem...:
# make perl
make
Sir,
I had created symbolic link from $ORACLE_HOME/libclntsh.so.8.0 to
/usr/lib/libclntsh.so.8.0 and /lib/libclntsh.so.8.0 now I am getting
following error.
The strange thing is that same set up is working fine on another machine
of linux.
pls suggest as to how this problem could be resolved.
A lot of times this has to with your LD_LIBRARY_PATH.
If it is CGI scripts giving you headache then first,
try creating a CSH wrapper for the script
#!/bin/csh
setenv LD_LIBRARY_PATH
$ORACLE_HOME/lib:$LD_LIBRARY_PATH
myscript
---
If that solves it then you could set that in your
Apache set
Hello all,
Can i find the difference between two times in perl programming
Please do help me
it is urgent
--
Regards,
Charitha.
Sir,
I have tried the workaround suggested by you but it did not help
Infact I tried to pass all env varaible in perl script also but of no
avail.
on my machine, all the users have bash shell,I have tried rebuilding
oracle:dbd after setting the path for LD_LIBRARY_PATH but did'nt work
I think
This has nothing to do with DBI. It's also in the fine manual (perldoc
perlfunc).
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a
29 matches
Mail list logo