Wrong forum for MySQL but you're getting the error because unless you created a 
view/table for "all_tables" then it doesn't exist. I suspect you're trying to 
use the view "USER_TABLES" or "DBA_TABLES" (if you have the GRANT to view that 
DBA view.



[EMAIL PROTECTED] wrote:

>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
>
> 
>
>

__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to