Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB 19c

dcj-OCAug 10 2021

I'm 19c Rookie - after spending past 8 years in 11.2.0.4.
19c Quarterly patches include security patches and updates. And - it has a new subversion (ie, 19.9; 19.10; 19.11, etc). By default - my Oracle Home was the full version name. 11.2 and all CPU patches, updates to 11.2 where applied there.
How are you handling/naming the 19c Oracle home? just leave it as 19? And patch accordingly to that Home? Build new home each time patch applied?
Links do not work - datapatch will not work with linked $ORACLE_HOME
Thanks for ideas, suggestions, recommendations - and sharing what you have learned !

Comments

Billy Verreynne

There are 3 basic ways to add an image to HTML e-mail.
Via an URL to the image on a web server. This will be blocked by default by most e-mail readers, and needs to be explicitly allowed by the user for the mail reader to access it.
By base64 encoding of the image into the SRC attribute of the IMG element. E.g.

<img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2
wCEAAkGBxITEBMUEhAVFRIWFRYWGBUVGSQeFRkhIBIWHBciFh8kICgsHyAxIBYX
...">

Or attaching the image to the e-mail, and pointing the SRC attribute of the IMG element to the attachment's content identifier. E.g.

<img src="cid:attachment-content-id">
RicardoS

@billy-verreynne here's my HTML code, I haven't yet tried the base 64 encoding yet, just unsure how to store it as I presume it would need to be shortened. (This is using the email templates)
<b>Dear #CUSTOMER#,</b><br>
<br>
You have been granted access to ESA Risk's Debtabase.</b><br>
<br>
<table width="100%">
<tr>
<th align="left">Username</th>
<td>#USERNAME#</td>
</tr>
<tr>
<th align="left">Password</th>
<td>#PASSWORD#</td>
</tr>
<br>
<th align="left" valign="top">Please login at https.//app.debtabase.com, where you will be prompted to change your password.</th>
</br>
<tr>
<th align="left" valign="top">Kind regards,</th>
</tr>
<tr>
<th align="left" valign="top">Debtabase Administration Team</th>
</tr>
<tr>
</table>
<br>
<img src="#APP_IMAGES#ESA-RISK.jpg" width="100" height="100"/>
</br>

Billy Verreynne

Unsure whether doing an inline encode of an image (especially one more than 12KB) is a good idea. Worth a try if smaller.
I prefer attaching the image to the e-mail and using a content-id reference to the attachment. I have however my own custom MIIME parser for creating the raw e-mail headers and body. Have not tried APEX e-mail interface and templates.
PS. sending full user credentials (name and password together), and including the logon URL, via unsecure medium like e-mail is a serious security risk

InoL

<img src="#APP_IMAGES#ESA-RISK.jpg" width="100" height="100"/>
Application images cannot be used outside an APEX session, so your email cannot retrieve the image. Store your image somewhere on a web server.
I wouldn't go the base64 route. A lot of mail clients cannot handle base64 embedded images. I found this article:
Embedded Image Support in HTML Email | Email List Validation (0 Bytes)
CID works, but not with APEX_MAIL. You will need to write your own mail procedure. I have a very old feature request for that:
https://apexapps.oracle.com/pls/apex/f?p=55447:19:107972467461859:::19:P19_ID:306600257061553126796642874179323699282

jariola

Application images cannot be used outside an APEX session, so your email cannot retrieve the image.
@inol , I think that isn't true at least on APEX 20.x and later. Or I do I miss something

InoL

I never realized that, but you are right, This is a static image in my application on apex.oracle.com:
Untitled ImageSo, for the OP: this is not enough:
<img src="#APP_IMAGES#ESA-RISK.jpg" width="100" height="100"/>
You need the complete path, not the relative path.

1 - 6

Post Details

Added on Aug 10 2021
2 comments
441 views