Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

How to concatenate 2 strings in one BLOB String to be able to insert into a media object text

edited Sep 19, 2013 3:13AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered
Hi To all
We are upgrading from XE to 9.1, just have finished the retrofit and I'm validating the custom developments

I have a customization of R42565 that calls a NER bsfn that adds a new line to the SO with an fixed item and then add an small text attachment

on XE we handled this with a direct insert in F00165 giving the kely to the new SO line, the text and the text lenght

Now in 9.1 I see that the string that holds the text has changed form an string to a binary blob

the problem is that i build the attached text with the use of several concat functions and now I find that the concat function do not work on the TXFT data type as it is a binary blob

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center