inserting value into LONG column [message #38974] |
Mon, 03 June 2002 01:17 |
Davide Cerri
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
Hi,
I'am tryng to insert data into a LONG column using a PL/SQL stored procedure.
The stored procedure code is something like:
---------------------------------------
CREATE OR REPLACE PROCEDURE myinsert (
parameter1 in VARCHAR2,
...
parameter10 in VARCHAR2)
AS
blk LONG;
BEGIN
blk := parameter 1||..||parameter10;
update mytable set long_column = blk
END;
/
-------------------------------------
I undestand that the problem is that a LONG PL/SQL variale can stores up to 32k bytes (at run time I have the following error:"ORA-06502: PL/SQL: numeric or value error") and the concatenation operator works just with varcha2.
How can I use the procedure to store long values ?
Thanks in advance for any suggestionù
Davide Cerri
|
|
|
|