upload form code: only thing I can see is the adslashes, that is not removed on out put - stripslashes.not sure if that is even related..
OPEN(v_lob,dbms_lob.lob_readwrite); dbms_lob.loadfromfile( v_lob, l_bfile ,amt); dbms_output.put_line('File length is: '
I am importing data from a non My SQL table into My SQL.When I query the record and select the blob in a popup editor, the blob appears unchanged.I tried then to update the procedure to update the blob with an empty_blob() and then run the script only to now have an empty blob. I can read the text field of the source table into a variable e.g. The My SQL table has been set, except for this data.I thought to use SQLString = "UPDATE The Table SET Notes = " mystring$ " WHERE The Table Ref = '" Myref$ "';" I get error: You have an error in the SQL syntax I have tried to search the manual for an example of updating a blob column from a variable and cannot find one.Note that the WRITE mutator can only be used on NON-NULL fields.