I am using VB6 and oracle.I want to insert a long field in a table. what insert statement shoud i use??
I use the insert sql statement. But Oracle gives me an error. "The string is too large..."
please anyone help me. it is a bit urgent.
Printable View
I am using VB6 and oracle.I want to insert a long field in a table. what insert statement shoud i use??
I use the insert sql statement. But Oracle gives me an error. "The string is too large..."
please anyone help me. it is a bit urgent.
check your table definition at Oracle database.
see what is the datatype and length ( max char) defined for the particular column you want to insert "large" text in.
Either modify the table definition such that it can store "larg" ( but definite, ofcourse length). It should work for you
Or..if changing table definition is possible ( for whatever reasons), try to change your logic at VB code so that it splits "large" text into "small" text string( equal or less then to the length defined at Oracle level)..and do multi ple insert.
Hope this helps:
check your table definition at Oracle database.
see what is the datatype and length defined for the particular column you want to insert "large" text in.
Either modify the table definition such that it can store "large " ( but definite length, ofcourse).
Or..if changing table definition is not possible ( for whatever reasons), try to change your logic at VB code so that it splits "large" text into "smaller" text strings( equal or less then the length defined at Oracle level)..and do multiple inserts.
Hope this helps: