Subject | Re: REPLACE() Retaining EOF marker from BLOB |
---|---|
Author | red_october2009 |
Post date | 2012-08-07T18:34:24Z |
Solution found: Just chop off the last character from the BLOB to be inserted, before doing the REPLACE()
Example:
vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1);
... Then do your REPLACE()
Example:
vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1);
... Then do your REPLACE()