Forms :: Making Form Of Email Sender
Mar 30, 2011I want to make form of email sender.
View 2 Replies
ADVERTISEMENT
PL/SQL :: Sending Email With Reply To Sender?
Sep 3, 2013In the database there is a job that monitors the delivered date.5 weeks before this date a email is send.I this mail i would like to implement a notification button. the receiver will get a mail with notification:o Yes i will succeedo No, i wil not succeed this answer has to be send back to the sender . how to do this. note: the receivers can have different mail clients!
View 10 Replies View RelatedForms :: How To Send Automated Email From Oracle Form
May 10, 2011I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,
View 1 Replies View RelatedCreated Registration Form With Input Field Of Email Address
May 30, 2011i have created a registration form with an input field of email address. now i want if a new user register, it should automatically receive a confirmation mail.
i have done some coding but i am unable to define what to write on place of highlighted text.
public void sendConfEmail(){
try{
Properties props = null;
if (props == null) {
props = System.getProperties();
}
props.put("mail.smtp.host", "<server host name>");
Session session = Session.getInstance(props, null);
[code]..
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Forms :: Opening Form Has Attached Libraries Caused Form Close
Jul 19, 2010If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
Forms :: Want To Call Web Form For Uploading Image From Custom Form
Apr 16, 2013I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedForms :: How To Reload Calling Form After Closing Called Form
Jul 15, 2007I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
Forms :: 2 Different Form To Pass Values From One Form To Another
Mar 11, 2010is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies View RelatedForms :: Send Email Through 6i?
Nov 11, 2011i want to send email and message on mobile phone through forms 6i.
View 1 Replies View RelatedForms :: Sending Email Through 6i
Apr 4, 2011How to send an email through oracle FORMS6i ?
View 1 Replies View RelatedSQL & PL/SQL :: Making Audit Trail
Oct 7, 2011I want to make Audit Trail on every DML operation users does on record. I have many more tables but I mention some example tables.
My Tables are
Invoice Table
Ref_Number char(12), -- Auto Generated
Invoice_No char(12),
Date Date,
Date_Created Date,
Created_By char(50),
Modify_By char(50),
Date_Modified date,
Amount number;
Receipt Header Table
Receipt_No Char (12),--Auto Generated
Date Date,
Date_Created Date,
Created_By char(50),
Modify_By char(50)
Date_Modified date;
Receipt Detail Table
Receipt_No Char (12),
Serial_No,
Doc_Number Char(12),
Date_Created Date,
Created_By char(50),
Modify_By char(50),
Date_Modified date;
Forms :: Email In Body But Not In Attachment
Jun 19, 2009I am sending email with attachment (word, pdf) without any problem. Now what i want is, instead of attachment that pdf / word file should come in body part , like means in internet explorer pdf open inside the browser itself while surfing. so means as soon as user open email, content of word / pdf should display in body part. how can i do this. using forms 6i, and database 10g.
View 7 Replies View RelatedForms :: How To Send Email From Oracle 10g
Sep 27, 2011I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.
View 16 Replies View RelatedForms :: 10g - Send Email From Application?
May 28, 2013I want to send an email from my Application forms 10g .But I receive
DECLARE
l_mailhost VARCHAR2(64) :=... //admin mail
l_from VARCHAR2(64) := ... //admin mail
l_to VARCHAR2(64) := ...//user mail
l_mail_conn sys.UTL_SMTP.connection;
[Code] ........
message displayed is: no internet connection !!
Forms :: Email To Multiple Recipient?
Dec 12, 2012How can I send mail to multiple recipients using UTL_SMTP.
Separating recipients (TO list) with ';' (semicolon) is not working.
Forms :: Email Send From Oracle 6i?
Jun 25, 2012tell the setting and code how send email through oracle?
View 4 Replies View RelatedForms :: Email Using Outlook Express From 10g
Feb 6, 2010I am supposed to open an Outlook Mailpage with the To address Hard-coded on the click of a button from the menu bar. I have an approach in mind but am not sure how far this works.
Create a button and in the When-button pressed trigger,use web.show_document to open the outlook page but I am stuck in the early stages only as I don't know the URL I am supposed to call to open an Outlook express.
SQL & PL/SQL :: Making Vertical Records To Horizontal
Aug 18, 2010I need to build a query on making a vertical records to horizontal records. I did read somewhere saying that we can use decode function. But im still trying to understand how decode function can make a vertical records to horizontal records.
View 4 Replies View RelatedPL/SQL :: Making Sql To Only Return Last 12 Months From Date?
Apr 21, 2013i have written an sql to look as sales orders but i want it to only return the last 12 months worth of sales for the date its run, the date file [sdtrdj] is julian date so i used to_char to conver it to dd-mm-yyyy how can i get it to only return the last 12 months from the date its run
select
sdshan As "Location", sddcto As "Order Type", sddoco As "Order Number",sdlitm As "Product Code", sddsc1 As "Product Description",
to_char(to_date(sdtrdj + 1900000, 'yyyyddd'),'DD-MM-YY')As "Order Date", sduorg As "Order Qty", sdaexp As "Extended Amount", sdsoqs As "Quantity Shipped",
ibsrp4 As "Srp4", ibsrp6 As "Srp6", ibsrp7 As "srp7", ibsrp9 As "Srp9", ibsrp0 As "srp10", sdsrp2 As "Franchise"
From proddta.f4211, proddta.f4102
Where sdmcu = ' UKC001'
and sddcto = 'KO'
and sdlitm = iblitm and sdmcu = ibmcu
and sdsrp2 In ('504','973','322','236','232','856','233','566','590','470','343','266','279')
Forms :: Validate Field To Be Valid Email ID?
Feb 16, 2011want to validate a field to be a valid email id.
View 1 Replies View RelatedForms :: Sending Email With Report In PDF As Attachment?
May 1, 2009I have the following code to send an email with a report as an attachment via forms. everything is running fine.
Now i do not have a message body in the email, so my question is how do i add some text as an email body
if i add the following parameter, its not working
ADD_PARAMETER(thelist, 'BODY',TEXT_PARAMETER, 'Check the attached Report');
DECLARE
report_id REPORT_OBJECT := find_report_object('checklist');
report_message VARCHAR2(100) :='';
rep_status VARCHAR2(100) :='';
[code]....
Forms :: Sending Email To Yahoo Or Gmail From 10g
Apr 23, 2010How to send email from Oracle forms10g to a yahoo or gmail account using authentication.
View 5 Replies View RelatedForms :: How To Send Pic And TEXT In Email Using PLSQL
Jun 13, 2010I am create procedure send the message in form bulider10g to Internet email and the procedure is work .
but now I want to modify this procedure , I want to add picture of my country ( logo ) and the original message . why cant display the image in my email ?
this code of image
<p align="center"><img border="0" src="logo.gif" width="20" height="20"></p>
I Think the problem of this code because 'Content-type: text/html' not image ?????!!!!!!!
utl_smtp.data(v_Mail_Conn, 'MIME-Version: 1.0' ||CHR(13)|| CHR(10)||'Content-type: text/html' || CHR(13)||CHR(10)||mesg);
procedure
EMAIL_SEN VARCHAR2(250);
EMAIL_REC VARCHAR2(250);
DESC_EN VARCHAR2(250);
UB_SEQ NUMBER(10);
BEGIN
DECLARE
v_From VARCHAR2(80) :=admin@yahoo.com ;
[code].........
Forms :: Sending Email With Attached Files?
Jun 15, 2010I am using the following code on a button and once I pressed the button the form disconnected.
Declare
Outlook_Object client_OLE2.OBJ_TYPE;
Mail_Object client_OLE2.OBJ_TYPE;
Item1 client_OLE2.OBJ_TYPE;
Item2 client_OLE2.OBJ_TYPE;
OLEPARAM client_OLE2.list_type;
[code]....
Forms :: Any Way To Load A Form Within A Form
May 21, 2010I have a requirement, is there any way i can achieve the following User Interface using oracle forms
Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.
The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.
Forms :: How To Open Another Form Within A Form
Dec 20, 2012I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.
In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.
This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.
Forms :: Pre-form And When-new-form-instance?
Mar 1, 2010What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
Cannot Connect To Database After Switchover Without Making Changes In TNS Entry
Nov 19, 2011I have an issue of not able to connect to the database after switchover without making changes in TNS entry after the switchover when I try to connect to then the primary database (which is standby before ) , the tns entry has entries for both the primary and secondary but the order of the primay and seconday database is to be changed manually till then it keep showing ERROR: ORA-01033: ORACLE initialization or shutdown in progress.
View 5 Replies View RelatedMaking A Select Statement To Join A Few Tables Together?
May 2, 2009I am trying to make a select statement to join a few tables together. What i would like to know is if i can do this by saying the following.
I want to select indviduals that have a skill, but i want to say that if they have any of these skills to show the name so for example
SELECT S.NAME
FROM EMPLOYEE S ,PROJECT_TEAM T, SKILL_LIST L
WHERE T.PROJECT = 'Tesco' AND
L.SKILLNO = 'skill1' or 'skill2' or 'skill3';