Skip to Main Content

Integration

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!

Getting statistics of Query Plan

2664040Apr 30 2014 — edited Apr 30 2014

Hi,

I have deployed a simple application on OEP default server (in localhost) in Eclipse. I can see the results in console when the generator send messages to port 9200. Also I can see the app is RUNNING when I check Event Processing Visualizer (http://localhost:9002/wlevs/)

However, in Query plan page, the stat result is always 0 for all the operators... I have take a look at all the related documentation but I couldn't resolve the problem.

Cheers,

Alireza

This post has been answered by 1008713 on Apr 30 2014
Jump to Answer

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
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 28 2014
Added on Apr 30 2014
3 comments
1,612 views