Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

SQL Attachment For Media Object

edited Mar 2, 2019 4:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 4 commentsAnswered

Hello - I am able to SQL query for media object attachment using the below query.

SELECT UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(GDTXFT,2094)) AS READBLOB

FROM TESTDTA.F00165 WHERE GDTXKY='200026'

Now, I would like to update the same media object to a constant value say "ABC" using SQL .

I tried using the update statement but it is throwing errors.

Any help to have the right SQL statement.

Best Regards, Harish

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