Has anyone been able to sucessfully make DBI and DBD::MySQL work under OSX -
Darwin? I'm not having any luck at all. I'm running Perl v5.6.0 built for
darwin. And I'm trying to install the MySQL modules version 1.2215, with
DBI version 1.14.0. My mysql database is version 3.23.28. When I
I am trying to bind a variable in_out but I keep getting:
PLS-00306: wrong number or types of arguments in call to 'TEST_INTONLY'
ORA-06550: line 3, column 5:
It is a simple test proceudre, it returns 99. The bind_in_out works
fine for ref cursors, but I will be damned if I can figure out why
Has anyone encountered any problems running the PERL DBI with Oracle
8.1.7?
I didn't have any problems with Oracle 8.1.5, but after an upgrade to
Oracle 8.1.7, I'm now getting the error message shown at the bottom of
this message. I checked and found that the Oracle.so file does exist.
I then
I encountered this same problem a few days ago, and the solution was to
reset the Oracle environment variables and the LD_LIBRARY_PATH var.
I have also run into some segmentation faults from the disconnect() method
when connecting to 8.1.7. Haven't tracked that down yet, though.
Good luck...
Nothing special at all really. Its 8.1.6 running under Win 2000 with linux
acting as a client system running the DBI code.
Its a strange duck I guess, I just know that if this is not set I start
getting wacky stuff, no results, blank pages etc with nothing logged into
my error logs.
Granted, I
I apologize for not including an example earlier, I was hoping someone
would identify an known error. I have made a smaller example of the
larger picture:
Code Sample:
my $stmt=$DBH-prepare('BEGIN
test_intonly( ? );
END;');
my
I guess the problem is with the type you bind to : ORA_RSET is for binding to
REF CURSORs, not for ints.
Why don't you try {ora_type = ORA_NUMBER} ?
Mark
[EMAIL PROTECTED] wrote:
I apologize for not including an example earlier, I was hoping someone
would identify an known error. I have
Hi
All,
I want to
set this environment on so that anything that the store procedure spits out will
show during the debug process within Perl DBI connection. Can someone
please show me how I can set this?
$dbh-do("SET SERVEROUTPUT ON");
Not
working. Please help.
Peter
Its nearly ready, just a few tests and some packaging left, so I'm looking
for alpha testers.
DBD::Chart puts a DBI frontend on GD::Graph and Chart::Plot,
using a simple SQL dialect. Check out http://home.earthlink.net/~darnold/dbdchart/
for details.
If you're interested in trying this out,
It's
this:
$dbh-func(dbms_output_enable);
Regards,
L
-Original Message-From: Loo, Peter # PHX
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001
12:02 PMTo: [EMAIL PROTECTED]Subject: SET SERVEROUTPUT
ON
Hi
All,
I want to
set this environment on so
LD_LIBRARY_PATH is an evil hack, don't set it.
http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-10/msg00010.html
John
[EMAIL PROTECTED]
Please remove me from the list. I have tried in vain to do so in the
normal way.
I am trying to install DBD::Oracle 1.06 on HP-UX 11.0 using Perl version
5.6.0 for Oracle 7.3.4.
I was able to successfully install the DBI 1.14 interface, but when I try
and install the DBD package, it fails. The perl Makefile.PL command seems
to work without any errors - just a warning that I
-Original Message-
From: Johnathon Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 5:21 PM
To: [EMAIL PROTECTED]
Subject: remove me from list
Please remove me from the list. I have tried in vain to do so in the
normal way.
Awesome, thanks John!
John-
On Tue, 20 Feb 2001, John D Groenveld wrote:
LD_LIBRARY_PATH is an evil hack, don't set it.
http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-10/msg00010.html
John
[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, Jan 20, 2001 at 11:03:05PM -, Haris wrote:
^^^
Your system clock is a month off. Anyway
Hello,
As far as I understood after reading the docs about placeholders in sql
commands,
that the benefit gained is only for that
Hi all,
Just wanted to thank everyone who helped shed light for
me. It worked out great in my test program below so I will add it to my
production program now. Thanks a bunch.
#!/usr/bin/perl
use DBI;
$ENVR = cwd() =~
/devl/ ? "devl" : "prod";
require
Hello,
As far as I understood after reading the docs about placeholders in sql
commands,
that the benefit gained is only for that specific process. I was wondering
would it be possible to compile all the sql statements at server startup.
That way all users will get the benefits .I use
I'm getting:
DBD::Oracle::db disconnect failed: ORA-00600: internal error code,
arguments: [729], [360], [space leak], [], [], [], [], [] (DBD ERROR:
OCISessionEnd)
This is after calling a stored procedure which returns some data through
a inout parameter around 50 times. The disconnect is in
19 matches
Mail list logo