Search code examples
vb.netoracle-databaseblobclob

Store large data into Oracle field


Can anyone tell me about how to store large data from vb.net to oracle field. I tried in blob as well as clob. but it is always showing error:

ORA-01704: string literal too long.


Solution

  • declare
    vClob varchar2(32767) := 'very very very.........very very very long text'
    begin
    update TABLE set FIELD = vClob