Ok that cleans it up a little for me.
Funny according to the OIC trace you are connecting
see below
> To: dbi-users@perl.org
> From: mstrum...@gmail.com
> Subject: Re: DBI Error: END failed--call queue aborted.
> Date: Wed, 17 Nov 2010 07:50:30 -0800
>
> On Nov 13, 10:19 am, sco...@pythian.com (John Scoles) wrote:
> > You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
> > 1.26 ans see what happens
> >
> > cheers
>
> The error remains the same :( Thanks for all your help. Not sure what
> else I can do here.
>
> -bash-3.00$ cat test.db.pl
> use strict;
> use DBI;
> my $dbh = DBI->connect( 'dbi:Oracle:<DELETED>',
> '<DELETED>',
> '<DELETED>',
> {dbd_verbose => 15}
> ) || die "Database connection not made:
> $DBI::errstr";
> $dbh->disconnect;
> print "Done. :)\n";
>
> -bash-3.00$ perl -w test.db.pl
> Environment variables:
> MANPATH=/opt/SUNWspro/man
> TERM=xterm
> SHELL=/usr/bin/bash
> SSH_CLIENT=172.28.2.66 3369 22
> OLDPWD=/export/home/webdev/.cpan
> SSH_TTY=/dev/pts/4
> USER=webdev
> LD_LIBRARY_PATH=/opt/instantclient10_1
> TNS_ADMIN=/opt/instantclient10_1
> MAIL=/var/mail//webdev
> PATH=/usr/bin:/opt/SUNWspro/bin:/opt/instantclient10_1:/usr/
> ccs/bin
> PWD=/export/home/webdev
> JAVA_HOME=/usr/java
> TZ=US/Eastern
> SHLVL=1
> HOME=/export/home/webdev
> LOGNAME=webdev
> SSH_CONNECTION=172.28.2.66 3369 172.28.1.40 22
> ORACLE_HOME=/opt/instantclient10_1
> _=/usr/bin/perl
> OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
> OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
> OCIEnvNlsEnvCreate(1b56bc,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
> OCIHandleAlloc(2500a0,1b56c0,OCI_HTYPE_ERROR,0,0)=SUCCESS
> OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78090,0,31,267a28)=SUCCESS
> OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78092,0,262,267a28)=SUCCESS
> charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII
> (csid: utf8=871 al32utf8=873)
The above set up you server context
> OCIHandleAlloc(2500a0,1b56c4,OCI_HTYPE_SERVER,0,0)=SUCCESS
> OCIHandleAlloc(2500a0,1b56c8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> OCIServerAttach(267fb4, 267a28, "AHST90", 6, mode=DEFAULT, 0)=SUCCESS
> OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,267fb4,0,Attr=OCI_ATTR_SERVER,267a28)=SUCCESS
> OCIHandleAlloc(2500a0,1b56cc,OCI_HTYPE_SESSION,0,0)=SUCCESS
The above sets up all your handles
> OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6380,3,Attr=OCI_ATTR_USERNAME,267a28)=SUCCESS
> OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6390,5,Attr=OCI_ATTR_PASSWORD,267a28)=SUCCESS
> OCISessionBegin(2679b4,267a28,270ca8,1,mode=DEFAULT 0)=SUCCESS
> OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,
> 270ca8,0,Attr=OCI_ATTR_SESSION,267a28)=SUCCESS
The above users your PW and UN and creates a session and it connects
The rest below is what happens when you disconnects
> OCISessionEnd(2679b4,267a28,270ca8,mode=DEFAULT 0)=SUCCESS
> OCIServerDetach(267fb4,267a28,mode=DEFAULT,0)=SUCCESS
> Done. :)
> OCIHandleFree(270ca8,OCI_HTYPE_SESSION)=SUCCESS
> OCIHandleFree(2679b4,OCI_HTYPE_SVCCTX)=SUCCESS
> OCIHandleFree(267fb4,OCI_HTYPE_SERVER)=SUCCESS
> OCIHandleFree(267a28,OCI_HTYPE_ERROR)=SUCCESS
You are now our of OCI/DBD/Oracle
> Out of memory!
So this Out of memory error happens after you have left
Can you run a query with your connection handle??
> Callback called exit.
> END failed--call queue aborted.
>
> --
> i5mast
>
