[oracle-l] Re: fetching long variable in PL/SQL
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jan 2004 10:57:18 -0800
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@xxxxxxxxxxxxxxxxxxxxxx
>=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
Other related posts:
