BWHAlvaro
Member
Hello,I am making an application in Visual with a connection to JDE, and in this application I update the data in table F00165.An example of an update is the following:
UPDATE (
SELECT utl_raw.cast_to_varchar2(dbms_lob.substr(GDTXFT)) as TEX, GDTXFT,GDOBNM as Type,GDTXKY as Order,GDMOSEQN as sequence, NVL(TRIM(GTMOCATCD1),' ') AS CAT
FROM F00165 LEFT JOIN F00166 ON GDTXKY=GTTXKY AND GTOBNM=GDOBNM AND GTMOSEQN=GDMOSEQN
WHERE GDGTMOTYPE=0 AND GDTXKY='50062|WO||A' AND TRIM(GTMOCATCD1) IS NULL ) p
SET GDTXFT =RAWTOHEX ( utl_raw.CAST_TO_RAW('test text'));
This performs the update for me, but when viewed in JDE it comes out with strange characters, unreadable for the user.
Could someone help me find the solution?
My version is 9.20
UPDATE (
SELECT utl_raw.cast_to_varchar2(dbms_lob.substr(GDTXFT)) as TEX, GDTXFT,GDOBNM as Type,GDTXKY as Order,GDMOSEQN as sequence, NVL(TRIM(GTMOCATCD1),' ') AS CAT
FROM F00165 LEFT JOIN F00166 ON GDTXKY=GTTXKY AND GTOBNM=GDOBNM AND GTMOSEQN=GDMOSEQN
WHERE GDGTMOTYPE=0 AND GDTXKY='50062|WO||A' AND TRIM(GTMOCATCD1) IS NULL ) p
SET GDTXFT =RAWTOHEX ( utl_raw.CAST_TO_RAW('test text'));
This performs the update for me, but when viewed in JDE it comes out with strange characters, unreadable for the user.
Could someone help me find the solution?
My version is 9.20
