CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Oracle SQL F00165 coming with "0" at each character

I created the following DB function, which I expect will retrieve the text from table F00165.

(Usage in F00165):

The problem is that it retrieves the text in the following BLOB format:

This is an issue because when I convert this into CLOB, those zeroes are converted into "invisible" characters:

I read that this is related to the Character Set F00165 is configured with, but how can I then translate F00165 into a usable string without needing to modify such string after applying the CLOB conversion to it? Today trying to use the resulting text generates completion errors.

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