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>
