Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Media object update via SQL

  1. #1
    New Member
    Join Date
    Aug 2007
    Location
    UK
    Posts
    7

    Media object update via SQL

    Hi,

    Hopefully someone will be able to assist with the issue I am having with media objects in JDE, I am trying to update (F00165) JDE media objects through an Oracle view via SQL.
    I am able to read the media object and display the text, however when it comes to updating the media object all seems OK except when viewing in JD Edwards the text displays as what seem to be Chinese symbols. If I select from the F00165 table and convert the text using utl_raw.cast_to_raw(text) the data displays as expected.

    Do I need to convert the text when writing it back to F00165? Do I have a character set issue?

    The character set currently set on the system are :

    NLS_CHARACTERSET = WE8MSWIN1252
    NLS_NCHAR_CHARACTERSET = AL16UTF16

    Thanks in advance,

    Jamie


  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,247

    Re: Media object update via SQL

    Jamie,

    are you writing the text using Rich Text Format?
    are you updating other fields in the F00165 such as text length?
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    Senior Member Alex_Pastuhov's Avatar
    Join Date
    Jul 2001
    Location
    Australia
    Posts
    1,747

    Re: Media object update via SQL

    In XE, this BLOB actually contains binary data, so you really should not manipulate it using SQL at all.
    Regards,
    Alexander Pastuhov
    http://www.everestsoftint.com/

  4. #4
    New Member
    Join Date
    Aug 2007
    Location
    UK
    Posts
    7

    Re: Media object update via SQL

    Hi alex thanks for the reply, we have previously done this in xe and it worked fine, we are upgrading now to e9 this is where we have the issue. All works ok except when view in JDE.

  5. #5
    New Member
    Join Date
    Aug 2007
    Location
    UK
    Posts
    7

    Re: Media object update via SQL

    Hi Larry,

    Yes the text is written in rich text format via an oracle view. Does the text length field exist in E9 on the F00165? I am not updating this value if it does. I know that this was present in XE and everything worked fine, its only now we are upgrading to E9 we are having issues.

    Is this an unicode issue or an issue to do with the character set we have set?

    Thanks,

    Jamie

  6. #6
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,567

    Re: Media object update via SQL

    If you are doing this in 9.0 look at all the jdeGTxxxxxxx api calls in jdekproto.h. Pretty much has everything you need to work with media objects of all types and multiple attachments per key, etc.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  7. #7
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,247

    Re: Media object update via SQL

    Oops - you're right - Text Length was a XE thing - not there in 9.0
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  8. #8

    Re: Media object update via SQL

    Hi ALL,
    I have the same issue to update text in Media object table F00165.
    When update with normal update command the text is updated and visible in utb but i found there is diffence in the format as it is missing some extra characters in the blob field.
    When viewed from application it looks like chines characters.
    Can any one please let me know how to convert this to blob format.

    Thanks in advance
    E812
    8.98.31

  9. #9

    Re: Media object update via SQL

    Hi Jamie,
    did you update in the BLOB field with plain text through normal update statement or you have converted to BLOB before updating.Please let me know.
    I have an issue to update the same media object BLOB field.

    Thanks
    E812
    8.98.31

  10. #10

    Re: Media object update via SQL

    Were you able to resove your issue, if yes could you help me as I am trying to do an insert into F00165.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.