Skip to Main Content
Forums

APEX

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!

Auto complete fields on Tabular Form

TexasApexDeveloperJan 14 2016 — edited Jan 20 2016

Using APEX 5 and Theme 42, I have a form (Page 245) in the below application that has two columns currently as lov popup controls.  My customer has asked if they can be converted to autocomplete textboxes.  Can anyone take a look at this page and suggest how to implement an autocomplete textbox for this style tabular form?  It is built using a interactive report and a collection underneath to hold data until its ready to be saved.. Idea is from Jari Lane's fantastic blog Jari's APEX Blog : Article Yet another way to create "editable interactive report"

URL for application: https://glassfish1.revion.com/apex/f?p=4550:1:6270623494473:::::

Application: recharge (Application # 393)

workspace: homeworld

user: demo

password demo

Any help will be appreciated!

Thank you,

Tony Miller
Los Alamos, NM

Comments

Alok Dubey
Hi Sourav,
What is the code u r using to send the mail. In general utl_smtp is used to send the mail. For further information u can search in this forum, where in we've many examples. If u've written any code then do display the code. so that any one of us can help you.

Regards,
Alok Dubey
Hafed Benteftifa
Hello,

There are several options for sending email.

1) Write a stored procedure using utl_smtp or utl_mail (new with 10g). This is the easiest to implement. See for example: www.psoug.org/reference/utl_mail.html
Problems you can have here: your smtp server does not allow you to send email or won't relay emails from your side. Most problems I have seen with this implementation were related to the smtp server.

2) Use the javamail PJC/javabean from the Oracle PJC demos. This one is a bit easier to implement but does require some preliminary setup. You might have to check the smtp server again and make sure it can relay your emails.

Hope this helps.
Andreas Weiden
a third option is to use OLE (or CLIENT_OLE in 9i, 10g) and send the mail via outlook.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 17 2016
Added on Jan 14 2016
#apex-discussions
13 comments
2,451 views