Well I sent this message to both the mysql mailing list and this perl list, because I am using perl to accomplish this, and mysql to talk to.
But anyway, thank you very much your number 3 EXACTLY fixed my issues, so the person with the right answer contacted me. Again, thank you very much for your assistance. Chris Hood -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 01, 2005 8:02 AM To: Christopher L. Hood Cc: mysql@lists.mysql.com; beginners@perl.org Subject: Re: DBD::Oracle issue Hi, I'll try even if this is not a neither oracle nor perl-dbd list. 1. verify that NLS_LANG is correct in your client env (and all the other ORA vars) 2. verify the query is simply quoted (" needs \_ for _) 3. Put all oracle variables in BEGIN {ORACLe_HOME=""}; in the perl script 4. verify that select * from dual is OK Mathias Selon [EMAIL PROTECTED]: > ALL, > > > > Can someone help out with this error: > > > > DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication > protocol error (DBD ERROR: error possibly near <*> indicator at char 23 in > 'select table_name from <*>all_tables') [for Statement "select table_name > from all_tables"] at ./oracleTest.pl line 66. > > > > I have tried to set TWO_TASK environment variable to no avail. > > > > The oracle connection is a remote connection made. > > I have successfully looked up other information in the database with this > script. > > The actual SQL command being run is "select table_name from all_tables". > > > > If anyone needs the actual script that is being run please mail me. But I > believe this error is specific to the select statement being run because > other selects work just fine. > > > > ANY ideas / suggestions would be greatly appreciated, > > > > Chris Hood > > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
