Perhaps I was unclear in the way I wrote my previous reply. Root privileges are not neded to do what I suggested.
Log in to the box as Oracle, download, build and install your own copy of Perl, DBD::Oracle, DBI and other modules in the Oracle account. Your perl might then be /home/oracle/perl/bin/perl. I have done this for several years on man *nix boxes, usually without root privileges. Works great. Jared On Tue, 2004-09-07 at 01:15, [EMAIL PROTECTED] wrote: > 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 > > > >
