We need Dynamic SQL to build the object from text strings. Another problem to deal with is that the source for some database objects can exceed 32,767 characters, the maximum limit for VARCHAR2 ...

For example, the account supporting the product catalog application described above should have read-only access to the product table. This would prevent the application from passing along a query ...

You create a CLOB in Oracle through the database's Structured Query Language, or SQL. Using SQL's "ALTER TABLE" statement, you add a CLOB data item to an existing table in your business' database.