Re: substr of LONG datatype?

Hi,
There are several limitations on the LONG datatype. One such limitation is that You can declare a variable or argument of a PL/SQL program unit using the LONG datatype. However, you cannot then call the program unit from SQL.
Its better if you convert the LONG type to LOB Example:
ALTER TABLE x MODIFY (a CLOB);

Before you migrate, make sure that you know the limitations in migrating LONG's to LOB's
1)If a table is a part of a cluster, its LONG or LONG RAW column cannot be changed to LOB.
2)You cannot have LOB columns in the UPDATE OF list in the UPDATE OF trigger. LONG columns are allowed.
3)If a view with a LOB column has an INSTEAD OF TRIGGER, then you cannot specify a string INSERT/UPDATE into the LOB column. However, if this is a LONG column before the migration, then a string INSERT/UPDATE is allowed. So certain SQL statements which worked before will not work now.

see this URL for further info
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88879/adl08lo5.htm#121601

Hope it helped
Srivenu Received on Thu Feb 28 2002 - 08:54:07 CET