i need to insert and update a LOB-value by a stored procedure.
i didn't manage to pass the long string value as a LOB-parameter and do a simple insert/update. i just managed to pass the procedure a varchar2-parameter of a maximum of 32767 characters and to change the LOB-value by the DBMS_LOB.WRITE-method.
but i would prefer the other way. do i have to do some kind of type-conversion with the long string value to pass it on as a LOB-parameter?