Hi John,
Here you go,
###
From the generation of the Makefile:
###
sonic ~/Downloads/Folx/DBD-Oracle-1.23
; perl Makefile.PL
Multiple copies of Driver.xst found in:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/
/System
rther AFAICT.
I am currently struggling with this:
; perl spikes/db_connect.pl
dyld: lazy symbol binding failed: Symbol not found: _OCINlsEnvironmentVariableGet
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/Oracle/Oracle.bundle
Expected in: flat namespace
dyld: S
/auto/DBD/Oracle/Oracle.bundle
Expected in: flat namespace
dyld: Symbol not found: _OCINlsEnvironmentVariableGet
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/Oracle/Oracle.bundle
Expected in: flat namespace
Trace/BPT trap
I will have a look at some more of the
am experiencing some issues with DBD::Oracle on OS X 10.6 Snow Leopard.
>>
>> I have downloaded instant client Version 10.2.0.4 (32-bit) from:
>>
>> http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html
>>
>> Namely, the follow
I have got DBD::Oracle working on SL. Here's my perl -V ...
bash-3.2# perl -V
Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
Platform:
osname=darwin, osvers=10.0, archname=darwin-thread-multi-2level
uname='darwin neige.apple.com 10.0 darwin kern
DBD::Oracle on OS X 10.6 Snow Leopard.
I have downloaded instant client Version 10.2.0.4 (32-bit) from:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html
Namely, the following files:
- instantclient-basic-10.2.0.4.0-macosx-x86.zip
- instantclient-sqlplus
Jonas Brømsø Nielsen wrote:
> Hello,
>
> I am experiencing some issues with DBD::Oracle on OS X 10.6 Snow Leopard.
>
> I have downloaded instant client Version 10.2.0.4 (32-bit) from:
>
> http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_mac
Hello,
I am experiencing some issues with DBD::Oracle on OS X 10.6 Snow Leopard.
I have downloaded instant client Version 10.2.0.4 (32-bit) from:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html
Namely, the following files:
- instantclient-basic
Ok that narrows it down for me nicely.
hopefully I will get some time to look at it soon
might just be a simple var miss match
cheers
John Scoles
Charles Jardine wrote:
On 07/10/09 12:23, John Scoles wrote:
could be a bug
I would try the latest Trunk version of DBD::Oracle there were
Charles Jardine wrote:
> On 07/10/09 12:23, John Scoles wrote:
>> could be a bug
>>
>> I would try the latest Trunk version of DBD::Oracle there were
>> some fixes put in there to the Object model way back in July.
>>
>> you can find it at
>>
&g
On 07/10/09 12:23, John Scoles wrote:
could be a bug
I would try the latest Trunk version of DBD::Oracle there were some
fixes put in there to the Object model way back in July.
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
Sadly this doesn't fix the problem. It
could be a bug
I would try the latest Trunk version of DBD::Oracle there were some
fixes put in there to the Object model way back in July.
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
I will see if I ever get any free time in the near future if I can get
1.24 (the Beer
On 07/10/09 11:47, Martin Evans wrote:
Charles Jardine wrote:
I have encountered a problem with the 'extended' support for
objects in DBD::Oracle. Specifically, if $dbh->{ora_objects}
is true, any attempt to fetch a nested table of objects
causes perl to crash with a segme
Charles Jardine wrote:
> I have encountered a problem with the 'extended' support for
> objects in DBD::Oracle. Specifically, if $dbh->{ora_objects}
> is true, any attempt to fetch a nested table of objects
> causes perl to crash with a segmentation fault.
>
> Ve
I have encountered a problem with the 'extended' support for
objects in DBD::Oracle. Specifically, if $dbh->{ora_objects}
is true, any attempt to fetch a nested table of objects
causes perl to crash with a segmentation fault.
Versions:
OS: SLES10 SP2 (64bit)
Oracle: 10.2.0.4 (64bit)
On Tue, Oct 6, 2009 at 9:30 PM, Umaparvathy Krishnan <
umaparvathy.krish...@oracle.com> wrote:
> Need a favour from you.I am trying to install DBD::Oracle module in the
> machine of HP-UX. Facing the error as below.Please help me
>
>
>
> $ make
>
> r
Hi all,
I may need to upgrade our DBD-Oracle from 1.12 to a newer version where the
utf-8 flag is turned on automatically when fetching data from a utf-8 db. Is
there any way to prevent DBD-Oracle from setting this flag? My perl environment
does handle utf-8 but we -for now- I dont want this
under
Cheers
John Scoles
as one would be using
Bruce Johnson wrote:
here's my problem. Due to some ancient database infrastructure I
need to use an old version of DBD::Oracle compiled against an
Oracle 8i client libs.
We're setting ORACLE_HOME and LD_LIBRARY_PATH to be inherited fro
wrote:
here's my problem. Due to some ancient database infrastructure I need
to use an old version of DBD::Oracle compiled against an Oracle 8i
client libs.
We're setting ORACLE_HOME and LD_LIBRARY_PATH to be inherited from
Apache.
The problem is that this completely borks PHP/Oracle
here's my problem. Due to some ancient database infrastructure I need
to use an old version of DBD::Oracle compiled against an Oracle 8i
client libs.
We're setting ORACLE_HOME and LD_LIBRARY_PATH to be inherited from
Apache.
The problem is that this completely borks PHP/Oracle
On 2009-09-25 12:28:08 -0400, Danilson, John wrote:
> I am trying to install DBD::Oracle on my mac and I¹m having issues with the
> make test. But I think the issues begin earlier.
>
> Mac os/x 10.5.8 (intel)
> DBD-Oracle-1.23
[...]
> make returns the following warnings. I
Sorry, I don¹t follow your question. I am not a c programmer. Is there
some gcc command you wished me to try?
John.
On 9/25/09 1:58 PM, "Martin Gainty" wrote:
> curious as to what ObjectiveC says about using ld without compiling?
> http://developer.apple.com/mac/library/documentation/Develop
aucune responsabilité
pour le contenu fourni.
> Date: Fri, 25 Sep 2009 12:28:08 -0400
> Subject: Install issues. Os/x 10.5 and DBD-Oracle-1.23
> From: john_danil...@cable.comcast.com
> To: dbi-users@perl.org
>
> I am trying to install DBD::Oracle on my mac and I¹m having issu
I am trying to install DBD::Oracle on my mac and I¹m having issues with the
make test. But I think the issues begin earlier.
Mac os/x 10.5.8 (intel)
DBD-Oracle-1.23
environment: (note this is the full blown oracle server 10G for mac; not
just instant client. Sqlplus etc work fine
2009/7/29 Radek Šťastný
> Hello,
> I have several cases on client where the select from the query works
> as expected while when less conditions
> are set and more rows should be returned it locks and waits until I
> terminate it.
> On server the same script works fine!
> In sqlplus from clienr t
rpms (10.2.0.4 I tested also with same result)
DBD::Oracle-1.23 compiled from source (also tried 1.19 from source and
debian package libdbd-oracle-perl_1.21-2_i386.deb build from source)
export ORACLE_HOME=/usr/lib/oracle/default/client/lib
export LD_LIBRARY_PATH=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOM
Thanks,
Jeff
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, June 25, 2009 10:09 AM
To: Jeff Urlwin
Cc: dbi-users@perl.org
Subject: Re: DBD-Oracle 1.23 testing
Thanks allot Jeff just to let other know
the 58object.t errors are a know issue which should be fixe
Somewhat related to Jeff's mail.
I recently built DBD::Oracle 1.23 against Oracle instant client on a 32
bit linux box and got the following warning:
Reading /usr/share/oracle/10.2.0.4/client/demo.mk
WARNING: Oracle /usr/share/oracle/10.2.0.4/client/demo.mk doesn't define a
&#
Hi Folks
Jeff Urlwin has sent me the results he mentioned, for those of us who
can't see the attachment. I've uploaded it:
http://savage.net.au/SQL/dbd.oracle.1.23.html
--
Ron Savage
r...@savage.net.au
http://savage.net.au/index.html
: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, June 25, 2009 7:56 AM
To: Jeff Urlwin
Cc: dbi-users@perl.org
Subject: Re: DBD-Oracle 1.23 testing
Thanks for that Jeff but is does not seem the attachment whet though do
you thin you can send it to me directly??
cheers
John
Jeff Urlwin
Jeff Urlwin wrote:
Attached are my quick results from testing DBD::Oracle on 32/64 bit
clients, 10.2.0.4 and 11.1.0.7 in various (but not all) combinations.
I hope this helps, and I will research more of these, but I thought it
might help the group.
Regards,
Jeff
Thanks for that Jeff but is does not seem the attachment whet though do
you thin you can send it to me directly??
cheers
John
Jeff Urlwin wrote:
Attached are my quick results from testing DBD::Oracle on 32/64 bit
clients, 10.2.0.4 and 11.1.0.7 in various (but not all) combinations.
I
Attached are my quick results from testing DBD::Oracle on 32/64 bit clients,
10.2.0.4 and 11.1.0.7 in various (but not all) combinations.
I hope this helps, and I will research more of these, but I thought it might
help the group.
Regards,
Jeff
This
On 08/06/09 15:43, Martin Gainty top-posted as follows:
Good Afternoon Charles and Jeremy
Are there any potential side-effects for turning off
signal-processing? i am wondering what the implications might be for
turning off signal events to Processors for multi-process
configurations?
http://
manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Mon, 8 Jun 2009 15:05:53 +0100
> From: c...@cam.ac.uk
> To: peter.jer...@alcatel-lucent.com.au
> CC: dbi-users@perl.org
> Subject: Re: DBD-Oracle 1.23 reports ORA-24334 in t/58object
On 05/06/09 06:31, Peter Jeremy wrote:
I am trying to install DBD-Oracle 1.23 with Oracle 10.1.4 on Solaris
10 using the standard (Sun-supplied) perl. In order to make it build,
I need to edit mk.pm and Makefile, replacing '-xarch=v9' with
'-xarch=native' and changing .../o
John Scoles wrote:
> I think there is a bug in 11g EE that is causing 026exe_array to fail on
> test #2 I have reported it to Oracle but they are quite on the matter.
Chalk me down for that problem too on our shiny new Oracle 11G with
DBD::Oracle 1.23 (10G client end):
[martin DBD-Oracl
John Scoles wrote:
> I have been playing with this as of late and the
> Short answer is no with a but; and the
> Long answer is yes with a maybe.
>
> Right now with OCI (and hence DBD::Oracle as that is what is it written
> in) it is not possiable to directly select a xmltype.
I am trying to install DBD-Oracle 1.23 with Oracle 10.1.4 on Solaris
10 using the standard (Sun-supplied) perl. It's correctly building
32-bit objects but then attempting to link them in 64-bit mode against
64-bit libraries. I have worked around the problem by editing both
mk.pm and Mak
I am trying to install DBD-Oracle 1.23 with Oracle 10.1.4 on Solaris
10 using the standard (Sun-supplied) perl. In order to make it build,
I need to edit mk.pm and Makefile, replacing '-xarch=v9' with
'-xarch=native' and changing .../oracle/product/10.1.4/lib to
.../oracle/
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> cpan> get DBD::Oracle
This works fine for me. Perhaps try another CPAN mirror?
Are you able to download other modules?
All else fails, you can always download directly:
links http://search.cpan.org/dist/DBD-Oracle/
- --
Greg
A developer asked me:
"I need the DBI module installed on host for Perl. I need this in order
to connect to databases.
I also need the DBD::Oracle database driver.I need this in particular
to connect to the Oracle database. "
I get the following error, can you adv
On May 27, 2009, at 4:32 PM, Martin Gainty wrote:
Steve
try
use Env qw(LD_LIBRARY_PATH); # no sigil here
BEGIN
{
$ORACLE_HOME = '/remote/netdb/instantclient_10_2';
$LD_LIBRARY_PATH .= ":/remote/netdb/instantclient_10_2";
}
Sadly this still does not work.
DBI connect('...','...',...
galement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: stevenschlans...@berkeley.edu
> To: dbi-users@perl.org
> Subject: Re: ERROR OCIEnvNlsCreate with DBD::Oracle
it will wreak havoc on
the application using DBD::Oracle...
Is there any other solution?
I should have been more specific with this - hopefully some additional
information will help. By setting LD_LIBRARY_PATH causes the tests to
now fail with couldn't contact Oracle server, which is
try
unsetting ORACLE_HOME and setting LD_LIBRARY_PATH.
Ugh. This is extremely inconvenient. Is it possible to use -R (-
rpath for GNU ld) instead, so I don't have to set LD_LIBRARY_PATH?
Doing so seems to make the tests happier, but it will wreak havoc on
the application using DBD::
Hi,
We have a procedure which calls RAISE_APPLICATION_ERROR with a unicode
string but when the error is retrieved from DBD::Oracle, the string is
valid UTF-8 but not marked as such. This means when it is printed to a
file handle with utf-8 encoding it is double encoded (unlike unicode
data
Sat, 23 May 2009 09:34:18 +0100
> From: martin.ev...@easysoft.com
> To: dbi-users@perl.org
> Subject: Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.23 and Oracle 10.2 on
> Solaris x86
>
> Steven Schlansker wrote:
> > Hello fine DBI users list,
> >
> > I'
Steven Schlansker wrote:
Hello fine DBI users list,
I'm having a bit of trouble getting DBD Oracle 1.23 working with
Oracle Instant Client 10.2 (with SDK and SQLPlus) on
SunOS machinename 5.10 Generic_138889-03 i86pc i386 i86pc
I compile with a PREFIX set. Because I couldn't figu
Hello fine DBI users list,
I'm having a bit of trouble getting DBD Oracle 1.23 working with
Oracle Instant Client 10.2 (with SDK and SQLPlus) on
SunOS machinename 5.10 Generic_138889-03 i86pc i386 i86pc
I compile with a PREFIX set. Because I couldn't figure out how to
pr
Hi Yannis,
Here's a link I used to install DBD::Oracle using the instant client
on my Mac. I'm using the bundled Perl rather than ActiveState so I'm
not sure if the instructions will still work.
http://blacka.com/david/2008/11/12/how-to-install-dbdoracle-on-mac-os-x/
2009/5/7 Yannis Haralambous :
> Hi,
>
> I'm trying to install DBD::Oracle 1.23 under MacOS X 10.5 with ActiveState
> Perl 5.8. I'm getting the following error message:
FYI, DBD::Oracle comes with ActiveState perl v 5.10.
-Doug
Hi,
I'm trying to install DBD::Oracle 1.23 under MacOS X 10.5 with
ActiveState Perl 5.8. I'm getting the following error message:
dyld: Symbol not found: _Perl_hv_common_key_len
Referenced from: /usr/local/ActivePerl-5.8/site/lib/auto/DBD/Oracle/
Oracle.bundle
Expected in: dyna
r, there does seem to be something weird going on in the debug
output -- an off-by-one error in the third line of the output: ''755'
This is with DBI 1.51, DBD::Oracle 1.22.
On Fri, May 8, 2009 at 9:59 AM, Charles Jardine wrote:
> On 08/05/09 15:26, E R wrote:
>>
>&
On 08/05/09 15:26, E R wrote:
On Fri, May 8, 2009 at 5:40 AM, Charles Jardine wrote:
You do not say which perl driver your are using to talk to Oracle.
The DBD::Oracle driver binds all placeholders as strings by default.
Are you using DBD::Oracle?
Yes, I am using DBD::Oracle.
What other
On Fri, May 8, 2009 at 5:40 AM, Charles Jardine wrote:
>
> You do not say which perl driver your are using to talk to Oracle.
> The DBD::Oracle driver binds all placeholders as strings by default.
>
> Are you using DBD::Oracle?
Yes, I am using DBD::Oracle.
What other perl driver
942
Is there a way to ensure that the parameter is passed to Oracle as a string?
You do not say which perl driver your are using to talk to Oracle.
The DBD::Oracle driver binds all placeholders as strings by default.
Are you using DBD::Oracle?
--
Charles Jardine - Computing Service, University o
Yes I think you can
Give this a try
ORA_STRING, ORA_LONG, ORA_RAW, ORA_LONGRAW,
use DBD::Oracle qw(:ora_types);
.. connect as normal
$sth=$dbh->prepare("SELECT * FROM PRODUCTS WHERE VENDOR = :p_vendor");
$sth->bind_param(":p_vendor",'7553', { ora_typ
Hi,
I have a situation where I need a number to be represented as a string
in a place holder:
my $x = 7553;
$dbh->do("SELECT * FROM PRODUCTS WHERE VENDOR = ?", {}, $x);
I'd like the above to be the same as: SELECT * FROM PRODUCTS WHERE
VENDOR = '7553'
The VENDOR column is a VARCHAR2, and Oracle
I have just built DBD::Oracle 1.23 on the following platform
OS: SUSE Linux Enterprise Server 10 (x86_64)
perl: 5.10.0 (64bit)
Oracle: 10.2.0.4 (64bit)
DBI: 1.607
I am happy to report that all is well ... except ...
When I first ran 'make test', three of the tests in t/58object.t
Oops, forgot to send this on to the list.
Thanks for the help everyone. There were two issues that needed to be
addressed.
1. The full client install was not complete. It was missing the header files
as was suggested. I rsync'd all the files from an existing, successful full
install and it was ab
Jacob,
sun4-solaris-64int/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -
DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
In file included from Oracle.xs:1:
Oracle.h:37:17: oci.h: No such file or directory
Oracle.h:39:20: ocidfn.h: No such file or directory
Oracle.h:40:18: orid.h: No such file or directory
Oracle
Has anyone had any success installing DBD::Oracle 1.22 on Solaris 10
with Perl 5.8.4? I have tried a number of times from CPAN and also
downloaded it and have tried modifying the Makefile to no avail. I've
pasted the most relevant output below. Thanks in advance!
uname -a:
SunOS kennemo02d
Tim Bunce wrote:
> On Fri, Apr 24, 2009 at 10:20:07AM +0100, Martin Evans wrote:
>> Hi,
>>
>> Early this morning a perl process of ours got the following error
>> on stderr:
>>
>> DBD::Oracle::db do failed: ORA-24909: call in progress. Current
>> o
On Fri, Apr 24, 2009 at 10:20:07AM +0100, Martin Evans wrote:
> Hi,
>
> Early this morning a perl process of ours got the following error on stderr:
>
> DBD::Oracle::db do failed: ORA-24909: call in progress. Current
> operation cancelled (DBD ERROR: OCIStmtExecute) at
> /us
Hi,
Early this morning a perl process of ours got the following error on stderr:
DBD::Oracle::db do failed: ORA-24909: call in progress. Current
operation cancelled (DBD ERROR: OCIStmtExecute) at
/usr/lib/perl5/site_perl/5.8.8/DBIx/Log4perl/
db.pm line 83.
The first significant thing is that it
;
> give me half a moment to look at something I will get you another pathc in
> a few moments
>> Here you go ...
>>
>> stbaldwins-macbook-pro:dev stbaldwin$ ./no-bind.plx
>> Using DBI 1.607 and DBD::Oracle 1.23
>> OCIHandleAlloc(113000,42ba30,OCI_HTYPE_STMT,0,
> Here you go ...
>
> stbaldwins-macbook-pro:dev stbaldwin$ ./no-bind.plx
> Using DBI 1.607 and DBD::Oracle 1.23
> OCIHandleAlloc(113000,42ba30,OCI_HTYPE_STMT,0,0)=SUCCESS
> OCIStmtPrepare(2bdcc4,88d2e0,'
> SELECT TO_CHAR(d_val, 'DD-Mon- HH
Here you go ...
stbaldwins-macbook-pro:dev stbaldwin$ ./no-bind.plx
Using DBI 1.607 and DBD::Oracle 1.23
OCIHandleAlloc(113000,42ba30,OCI_HTYPE_STMT,0,0)=SUCCESS
OCIStmtPrepare(2bdcc4,88d2e0,'
SELECT TO_CHAR(d_val, 'DD-Mon- HH24:MI:SS')
FROM
the bottom of this?
>
> On 18/04/2009, at 9:15 AM, sco...@pythian.com wrote:
>
>> well with this code
>>
>> select(STDOUT);
>> $|=1;
>> p("Using DBI $DBI::VERSION and DBD::Oracle $DBD::Oracle::VERSION");
>>
>>
>> $dbh->trace
$DBI::VERSION and DBD::Oracle $DBD::Oracle::VERSION");
$dbh->trace(0);
my $sth = $dbh->prepare(q(
SELECT TO_CHAR(d_val, 'DD-Mon- HH24:MI:SS')
FROMTABLE(sb_func(?))
));
$sth->bind_param(1, 10);
p('Doing execute');
$sth->execute;
my $rows = 0;
well with this code
select(STDOUT);
$|=1;
p("Using DBI $DBI::VERSION and DBD::Oracle $DBD::Oracle::VERSION");
$dbh->trace(0);
my $sth = $dbh->prepare(q(
SELECT TO_CHAR(d_val, 'DD-Mon- HH24:MI:SS')
FROMTABLE(sb_func(?))
));
$sth->bind_p
John,
I see the same behaviour with the latest trunk. Is it possible it is
due to some interaction with the latest DBI (I'm at 1.607 and you're
at 1.601) ? ..
au-stb-101-144:dev stbaldwin$ ./no-bind.plx
Using DBI 1.607 and DBD::Oracle 1.23
DBD::Oracle::db prepare failed:
Seems it might be an in compatiably between NLS_LANG and the Char
you are
trying to read
Try this code again this time add the data to a NCHAR field that may
help
DBI version : 1.605
DBD::Oracle version : 1.22
Database: 11.1.0.7 (don't think this matters)
DB
ion : 1.605
> DBD::Oracle version : 1.22
> Database: 11.1.0.7 (don't think this matters)
> DB : AL32UTF8 (this definitely matters)
> NLS_LANG: AMERICAN_AMERICA.AL32UTF8
>
> Consider the following script ...
>
> #!/usr/bin/perl -w
>
>
Ran this through my system (windows) and I get the correct results
I am using the latest 'Trunk' version of DBD::Oracle
you might want to try it and see what you get
you can find it at
http://svn.perl.org/modules/dbd-oracle/trunk
my dbi is 1.601
cheers
John
> John,
, 123.456));
return;
end;
/
(change the program SQL to ...)
my $sth = $dbh->prepare(q(
SELECT TO_CHAR(d_val, 'DD-Mon- HH24:MI:SS')
FROMTABLE(sb_func(?))
));
When I run it I get this ...
au-stb-101-144:dev stbaldwin$ ./no-bind.plx
Using DBI 1.607 and DBD::Or
I have big problem - in my perl script I open two connection in Oracle
and DB2:
$db = DBI->connect("dbi:Oracle:ctginst1", "ais_polling", "x");
$dbh = DBI->connect("dbi:DB2:ASUP", "trset", "");
If first in script open connect in Oracle - script running and do
nothing - simple infinity
I will be working on this today.
Having trouble receating it as I do not have the scema for
msc$stats_report_p.schema_top_n(?))
can you get me that function or ne like it that returns something?
Cheers
John Scoles
> Here's a bit more information that may help. It looks like a
>
Here's a bit more information that may help. It looks like a
DBD::Oracle problem, but I could be wrong.
I did some tweaking of the statement to see what works and what
doesn't. I tried using the ? placeholder instead of the :var and
found something weird is going on.
I
Any comments/feedback on this?
On 09/04/2009, at 11:43 AM, Steve Baldwin wrote:
Hi,
I have a program that worked fine under DBI 1.52 and DBD::Oracle
1.22. Moving to the latest DBI 1.607 but the same DBD::Oracle, I
get a bind error.
Here's a sample program :
#!/usr/bin/perl -
Hi,
I have a program that worked fine under DBI 1.52 and DBD::Oracle
1.22. Moving to the latest DBI 1.607 but the same DBD::Oracle, I get
a bind error.
Here's a sample program :
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI qw();
use DBD::Oracle;
sub p{
printf @_;
Would be helpful it you told us your DBD::Oracle and Oracle Client
version as well
There are limits on what you can do with a remote view id the view has a
LOB.
Does your view have a CLOB or BLOB?
Deepening on your DBD::Oracle version we might be able to a very
detailed OCI trace on what
Hello,
I got a strange problem, and I need help to solve this.
I need to run an Oracle stored proc from perl. So far, nothing exceptionnal.
The problem is that I'm using a db link in the Oracle stored proc. I can run
it successfully from Toad and sqlplus, but I'm having issue when run from p
and shall not have any legally binding
> effect. Given that e-mails can easily be subject to manipulation, we can not
> accept any liability for the content provided.
>
>
>
>
>
>
> > Date: Mon, 6 Apr 2009 13:22:58 +1200
> > Subject: Re: DBD Oracle 1.20 ORA-24334 Error
, we can not accept any
liability for the content provided.
> Date: Mon, 6 Apr 2009 13:22:58 +1200
> Subject: Re: DBD Oracle 1.20 ORA-24334 Error
> From: jamie.nichol...@gmail.com
> To: sco...@pythian.com
> CC: dbi-users@perl.org
>
> Found the fix for the t/10gen.t e
Found the fix for the t/10gen.t exit code tests in the README.help.txt under
"repetitive connect/open/close/disconnect" tests
However still no luck with my initial test 'VARRAY of abstract data types',
it's still returning
DBD::Oracle::db prepare failed: ORA-24334: no des
gt; > -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
> > dbdimp.c
> > dbdimp.c: In function `ora_st_execute_array':
> > dbdimp.c:3269: warning: unused variable `sv2'
> >
> > Full output of the make,
> >
> N
gt; dbdimp.c
> dbdimp.c: In function `ora_st_execute_array':
> dbdimp.c:3269: warning: unused variable `sv2'
>
> Full output of the make,
>
Not sure if that would be the culperate. If I remember correctly I
removed it in 1.22 as it was a memory leak source. Try getting rid
`sv2'
Full output of the make,
ux11:/home/bmpe/bmpadme/DBD-Oracle-1.21 > make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (
ucessful perl Makefile.PL, make, then make test I read
> the
> following post by John
>
> http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32950.html
>
> I then ran the make install and re-tried my sample test but still the
> issue
> occurs, otherwsise standard SQL wor
Apologies for answering my own post, but I found this :
http://blacka.com/david/2008/11/12/how-to-install-dbdoracle-on-mac-os-x/
It seems to do the job.
Steve
On 04/04/2009, at 7:28 AM, Steve Baldwin wrote:
Has no-one got DBD::Oracle 1.22 running on OS/X Leopard?
Steve
On 02/04/2009, at
Has no-one got DBD::Oracle 1.22 running on OS/X Leopard?
Steve
On 02/04/2009, at 10:47 AM, Steve Baldwin wrote:
I'm attempting to build DBD::Oracle for the first time on a Mac.
Not much luck so far.
I'm attempting to build using the latest Instant Client. Here's
://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32950.html
I then ran the make install and re-tried my sample test but still the issue
occurs, otherwsise standard SQL works fine.
DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position
(DBD ERROR: OCIParamGet) [for Statement
Tried this using Oracle 1.21 on my Windoze PC and it works.
Looks like I'm off to upgrade the Oracle Client as per option 2 in this
archive
http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html
Hi,
I've installed DBD Oracle 1.20, on Solar
5.8,<http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html>
The make installed with a few bumps but the t/56embbeded was ok - which
contains the features I intend on using.
As part of my development I've created a ta
I'm attempting to build DBD::Oracle for the first time on a Mac. Not
much luck so far.
I'm attempting to build using the latest Instant Client. Here's what
happens ...
stbaldwins-macbook-pro:DBD-Oracle-1.22-DQ1QKH root# perl Makefile.PL
Using DBI 1.52 (for perl 5.008008 o
rprise Server 10 (x86_64),
> > installed DBI & DBD::Oracle. We are running Oracle 11g on this server.
> > Running a program that
> > uses DBI/DBD::Oracle, the process locked the server up by using all the
> > memory and swap. The server
> > has 32 gig of mem
Wanted to change the subject.
On Wed, 2009-04-01 at 11:11 -0500, Scott T. Hildreth wrote:
> Hello,
>
> I'm having a strange problem. I compiled 5.8.9 on SUSE Linux Enterprise
> Server 10 (x86_64),
> installed DBI & DBD::Oracle. We are running Oracle 11g on th
501 - 600 of 3939 matches
Mail list logo
