Get the full path of #APP_IMAGES in Oracle Apex
I want to know the full path of #APP_IMAGES in Oracle Apex which I have uploaded in Shared Component.
I have created one procedure to send email to users in outlook, through that procedure emails are triggering in a scheduled manner.
Please see below code:
v_mailbody:='<html> <head> </head> <body>'||'Hello '||cur.name||'<br>'||'<br>'||
'<h1 align="center" style="background-color:Tomato;">Happy Birthday! </h1>'||
'<img src="cid: #APP_IMAGES#ncr_img/File_000.jpeg" alt="Girl in a jacket" width="500" height="600">'||
Regards
Anshul Ayushya
oracle-apex oracle-apex-5
edited Nov 26 '18 at 13:23
chrisis
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
add a comment |
I want to know the full path of #APP_IMAGES in Oracle Apex which I have uploaded in Shared Component.
I have created one procedure to send email to users in outlook, through that procedure emails are triggering in a scheduled manner.
Please see below code:
v_mailbody:='<html> <head> </head> <body>'||'Hello '||cur.name||'<br>'||'<br>'||
'<h1 align="center" style="background-color:Tomato;">Happy Birthday! </h1>'||
'<img src="cid: #APP_IMAGES#ncr_img/File_000.jpeg" alt="Girl in a jacket" width="500" height="600">'||
Regards
Anshul Ayushya
oracle-apex oracle-apex-5
edited Nov 26 '18 at 13:23
chrisis
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
Note:cid:is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normalhttp://orhttps://protocol.
– Jeffrey Kemp
Nov 27 '18 at 2:39
add a comment |
I want to know the full path of #APP_IMAGES in Oracle Apex which I have uploaded in Shared Component.
I have created one procedure to send email to users in outlook, through that procedure emails are triggering in a scheduled manner.
Please see below code:
v_mailbody:='<html> <head> </head> <body>'||'Hello '||cur.name||'<br>'||'<br>'||
'<h1 align="center" style="background-color:Tomato;">Happy Birthday! </h1>'||
'<img src="cid: #APP_IMAGES#ncr_img/File_000.jpeg" alt="Girl in a jacket" width="500" height="600">'||
Regards
Anshul Ayushya
oracle-apex oracle-apex-5
edited Nov 26 '18 at 13:23
chrisis
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
I want to know the full path of #APP_IMAGES in Oracle Apex which I have uploaded in Shared Component.
I have created one procedure to send email to users in outlook, through that procedure emails are triggering in a scheduled manner.
Please see below code:
v_mailbody:='<html> <head> </head> <body>'||'Hello '||cur.name||'<br>'||'<br>'||
'<h1 align="center" style="background-color:Tomato;">Happy Birthday! </h1>'||
'<img src="cid: #APP_IMAGES#ncr_img/File_000.jpeg" alt="Girl in a jacket" width="500" height="600">'||
Regards
Anshul Ayushya
oracle-apex oracle-apex-5
oracle-apex oracle-apex-5
edited Nov 26 '18 at 13:23
chrisis
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
edited Nov 26 '18 at 13:23
chrisis
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
edited Nov 26 '18 at 13:23
chrisis
1,36951516
edited Nov 26 '18 at 13:23
chrisis
1,36951516
edited Nov 26 '18 at 13:23
chrisis
1,36951516
1,36951516
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
asked Nov 26 '18 at 11:09
Anshul AyushyaAnshul Ayushya
215
215
Note:cid:is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normalhttp://orhttps://protocol.
– Jeffrey Kemp
Nov 27 '18 at 2:39
add a comment |
Note:cid:is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normalhttp://orhttps://protocol.
– Jeffrey Kemp
Nov 27 '18 at 2:39
Note:
cid: is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normal http:// or https:// protocol.– Jeffrey Kemp
Nov 27 '18 at 2:39
Note:
cid: is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normal http:// or https:// protocol.– Jeffrey Kemp
Nov 27 '18 at 2:39
add a comment |
1 Answer
1
active
oldest
votes
The #APP_IMAGES# form for substitution strings can't be used in PL/SQL. You can call V('APP_IMAGES') to get the correct value. That returns a VARCHAR2, so you'd use it like:
... '<img src="cid:' || V( 'APP_IMAGES' ) || 'ncr_img/File_000.jpeg" ...
I'm not sure the cid syntax is what you want to use, though.
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
even after using'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg"I am unable to see picture in the email... could you please help me with this...
– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
add a comment |
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53479841%2fget-the-full-path-of-app-images-in-oracle-apex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The #APP_IMAGES# form for substitution strings can't be used in PL/SQL. You can call V('APP_IMAGES') to get the correct value. That returns a VARCHAR2, so you'd use it like:
... '<img src="cid:' || V( 'APP_IMAGES' ) || 'ncr_img/File_000.jpeg" ...
I'm not sure the cid syntax is what you want to use, though.
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
even after using'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg"I am unable to see picture in the email... could you please help me with this...
– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
add a comment |
The #APP_IMAGES# form for substitution strings can't be used in PL/SQL. You can call V('APP_IMAGES') to get the correct value. That returns a VARCHAR2, so you'd use it like:
... '<img src="cid:' || V( 'APP_IMAGES' ) || 'ncr_img/File_000.jpeg" ...
I'm not sure the cid syntax is what you want to use, though.
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
even after using'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg"I am unable to see picture in the email... could you please help me with this...
– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
add a comment |
The #APP_IMAGES# form for substitution strings can't be used in PL/SQL. You can call V('APP_IMAGES') to get the correct value. That returns a VARCHAR2, so you'd use it like:
... '<img src="cid:' || V( 'APP_IMAGES' ) || 'ncr_img/File_000.jpeg" ...
I'm not sure the cid syntax is what you want to use, though.
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
The #APP_IMAGES# form for substitution strings can't be used in PL/SQL. You can call V('APP_IMAGES') to get the correct value. That returns a VARCHAR2, so you'd use it like:
... '<img src="cid:' || V( 'APP_IMAGES' ) || 'ncr_img/File_000.jpeg" ...
I'm not sure the cid syntax is what you want to use, though.
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
answered Nov 26 '18 at 20:45
eaolsoneaolson
8,75163147
8,75163147
even after using'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg"I am unable to see picture in the email... could you please help me with this...
– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
add a comment |
even after using'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg"I am unable to see picture in the email... could you please help me with this...
– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
even after using
'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg" I am unable to see picture in the email... could you please help me with this...– Anshul Ayushya
Nov 27 '18 at 7:30
even after using
'<img src="' || V( 'APP_IMAGES' ) || '/ncr_img/File_000.jpeg" I am unable to see picture in the email... could you please help me with this...– Anshul Ayushya
Nov 27 '18 at 7:30
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
Is the resulting URL in the src attribute correct for your file? There are multiple reasons it may not be visible in the email.
– eaolson
Nov 30 '18 at 0:09
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53479841%2fget-the-full-path-of-app-images-in-oracle-apex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Note:
cid:is for images embedded in a multi-part mime message. If you want the mail recipients to pull the image from your APEX server you need to provide a static link using the normalhttp://orhttps://protocol.– Jeffrey Kemp
Nov 27 '18 at 2:39