Unfortunately, I do need to use the iAS for now. We don't have root
privileges on the box, changes to the system require that we contact IT
and have to put through a service request and all that stuff. We have a
Perl install on the box, but we're using the iAS libraries to talk to
everything else. There's an eventual upgrade to Oracle 9.2 coming, but
not for a while. It would be nice to solve this situation so if it comes
up again, I can handle it on the fly.
Thanks for your consideration, Jared.
Christopher R. Marbach
Data Quality Coordinator
Pharmacy Analytical Services
Kaiser Permanente
8-345-2485
(562) 401-2485
Jared Still <[EMAIL PROTECTED]>
09/06/2004 09:27 PM
To: Chris R Marbach/CA/[EMAIL PROTECTED]
cc: DBI List <[EMAIL PROTECTED]>
Subject: Re: Perl/DBI/ORACLE Troubles. Help, please!
On Wed, 2004-09-01 at 17:46, [EMAIL PROTECTED] wrote:
> Hello, I'm new to the list and am experiencing an issue that I hope some
> of you all have dealt with previous and can lend me some advise on.. or
> supply a possible fix.
>
> Perl 5.6.1 with DBI module 1.32 operating on AIX 4.3. I'm attempting to
> query an Oracle 9.0.1.0.0 database through the perl installed on the
> Oracle 9.0.3 iAS. Through Perl, I can insert and select counts with no
> problem. However, when I try to select values from fields, I'm getting:
>
> DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication
> protocol error (DBD ERROR: OCIStmtExecute) at tstora2.pl line 29.
>
Though I haven't looked in depth at the rest of your post, I would still
offer this advice: don't use the Perl supplied by Oracle unless you are
required to do so because you are using iAS.
You're much better off installing your own version of Perl. That allows
you to stay current without testing all the other stuff that would be
dependent on the Oracle version.
On unix this is fairly simple. Get the source and build it either in
~oracle or build one in each of your ORACLE_HOME, say
$ORACLE_HOME/myperl, or some such thing.
HTH
Jared
