I have a form with some text fields and a BLOB (storing image) column. For storing the BLOB column I was using webutil_file_transfer.client_to_db_with_progress procedure to transfer and store to BLOB column. In essence the BLOB column in the data block was only for querying the image to be shown to users.
But when I modify the text column and save the record I got an error message which I have never encountered till now.
ORA-24813: cannot send or receive an unsupported LOB
Thanks to my colleague Haris, I modified the data block property Update Changed Columns Only to "Yes" from default No. The error is now gone.
The error is solved by this simple property setting.
But when I modify the text column and save the record I got an error message which I have never encountered till now.
ORA-24813: cannot send or receive an unsupported LOB
Thanks to my colleague Haris, I modified the data block property Update Changed Columns Only to "Yes" from default No. The error is now gone.
The error is solved by this simple property setting.
thanks
ReplyDelete