CLOB variable [message #38336] |
Thu, 11 April 2002 06:16 |
Nagesh
Messages: 18 Registered: April 2002
|
Junior Member |
|
|
In my store proc, I am receieving an input od CLOB type. Then I have to replace pattern in the CLOB with a new text. To do that I am using DBMS_LOB.INSTR( ) to get the position and DBMS_LOB.WRITE(*, *, *, *). After I change the CLOB, I need to insert into a Table.
When I try to load the proc, I am getting an error message saying "PLS-00363: expression 'INPUT_VARIBLE' cannot be used as an assignment target"
|
|
|
Re: CLOB variable [message #38337 is a reply to message #38336] |
Thu, 11 April 2002 10:34 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
You will not be able to alter the input parameter. Instead, declare a variable in the proc of type CLOB and write the changes back to that variable and use it to do the insert into the table.
|
|
|
|