dbms_sql.column_value_long
An example of its use can be seen here:
http://otn.oracle.com/oramag/code/tips2003/020903.html
Searching for Text within the Trigger Body=20
This tip comes from Dejan Jovanovic, Oracle Applications Developer at =
Xerox in Dundalk, Ireland.
> -----Original Message-----
> A.Bahar_at_billing-components.com
>=20
>=20
> I have a problem about fetching long variable in PL/SQL.
> I encountered with problem in following PL/SQL block.
> When I try to fetch long variable , I receive " PL/SQL:=20
> numeric or=20
> value error ORA-06512".
> As I searched in metalink, it is releated to size of long=20
> variable.=20
> Probably it is greather than
> 32KB.
> I could not find a solution.
> Do you have any info or and advice that how I can fetch long=20
> variables greather than 32KB.
> May it can be divided into more than one variable but how.
>=20
Received on Mon Jan 26 2004 - 12:57:18 CST
