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