This discussion is archived
10 Replies Latest reply: Aug 1, 2013 6:31 AM by John_W RSS

How to display blob as text in APEX

2f75c9f8-5675-4cdb-9224-e5c4b5f19bd1 Newbie
Currently Being Moderated

hi All,

 

I am developing an apex application using the apex cloud (apex.oraclecorp.com). I am using the DB link to show the data on APEX UI. I have a blob data which is stored in the remote DB, and I want to display the BLOB data as text on a popup or a new page or a download link.

 

I tried using display only item but APEX throws an error saying that remote DB is not supported. Also, It would be great if I can just show a download link on the UI for the BLOB data, again when I try to select the format as BLOB in the column attributes, When I give the table@dblink as BLOB table I get an error saying that "table@DBLINK not found".

 

Is there any way to display the BLOB data as text or download it which is present in my local DB?


Please help me out.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points