Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Maximum length of string sent to dbms_sql

RE: Maximum length of string sent to dbms_sql

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 18 Sep 2000 16:49:41 -0400
Message-Id: <10623.117287@fatcity.com>


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. Received on Mon Sep 18 2000 - 15:49:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US