I am trying to build the DBD-1.12 with Oracle 9i. Everything compiles
into the object files, but it seems to build the files 32 bit rather
than 64 bit, so it fails on linking. I searched Google and found a
couple of references of people who manually manipulated the Makefile
and changed the libr
I have run into an odd issue, using oracle 9.2.0.4, and I am trying a
test based on the example in DBD::Oracle, using pipelined tables. I
made a small test package:
/*
@TEST_PKG.SQL
SELECT * FROM TABLE (TEST_PKG.F_TEST(6));
var c refcursor
exec TEST_PKG.TEST1(6,:c);
exec TEST_PKG.TEST2(6,:c);
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
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 $res
My DBA is having a fit because every connection from DBI/DBD Oracle is
issuing a ALTER SESSION SET TIME_ZONE='-04:00'; . She sees this as
unneccessary and a waste of resource. Is this really neccessary, and
is there a way to no do it?
--
C Wayne Huling <[EMAIL PROTECTED]>
Jonathan Leffler writes:
> On Mon, 8 Nov 2004 16:05:41 -0500, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > My DBA is having a fit because every connection from DBI/DBD Oracle is
> > issuing a ALTER SESSION SET TIME_ZONE='-04:00'; . She sees this as
> > unneccessary and a waste of resource.
Tim Bunce writes:
> I can assure that DBD::Oracle does no such thing.
>
I have no clue what the DBA is using to watch the session traffic, and
she isn't sharing very much with me... Any way, I have a simpel
DBI->connect call, and she sees the ALTER SESSION come through.
Depending on what I set T
You need to escape the $ in the second split:
#!/usr/local/bin/perl
use strict;
use Crypt::PasswdMD5;
my $password = 'CrapWork69'; #$ARGV[0];
my $salt = rand(99);
my $cryptpasswd = unix_md5_crypt($password, $salt);
my $line=sprintf 'vprasad:%s',$cryptpasswd;
my ($user,$cpasswd)=split (":",$
oracle 9.2.0.4 (client)
DBD-Oracle 1.16
DBI 1.40
Apache DBI 0.94
Perl 5.8.5
We recently moved from the web server and DB running on the same
machine to two seperate machines. Things started smoothly, but over
the weekend, we have seen some weirdness and really can't explain why
things work fine,
Tim Bunce writes:
> On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> >
> > Why is it that I can't get a response to my question: when will
> > DBD::Oracle fully support Oracle's array interface?
>
> I don't get paid to work on DBD::Oracle. It's a hobby, and one that
> generally
10 matches
Mail list logo