Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

numeric or value error.......for dbms_lob.write() function

612260Feb 4 2008 — edited Mar 19 2008
Hi,
I am getting an error "numeric or value error " for the below code
PROCEDURE PRC_CREATE_TEMP_CLOB(pi_original_clob IN OUT NOCOPY CLOB) IS
		l_tmp_clob clob;
		BEGIN
			 dbms_lob.createtemporary(l_tmp_clob, TRUE, dbms_lob.session); 
			 XmlDom.writeToClob(domDocument,l_tmp_clob);
			 dbms_lob.write(pi_original_clob,dbms_lob.getlength(l_tmp_clob),1,l_tmp_clob);
		   		END;
The error comes in the statement "dbms_lob.write"

Any idea what can be the error?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2008
Added on Feb 4 2008
8 comments
956 views