Message-Id: <10623.117287@fatcity.com> From: "Jamadagni, Rajendra" Date: Mon, 18 Sep 2000 16:49:41 -0400 Subject: RE: Maximum length of string sent to dbms_sql You can use the overloaded PARSE call to supply a SQL statement as a pl/SQL table where each row can contain max 256 chars. Thus you could have a SQL statement to the limit that oracle an theoretically support. For more information see $ORACLE_HOME/rdbms/admin/dbmssql.sql file ... HTH Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.