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>