Send email through procedure in PL/SQL

Dear Team, I want to make a procedure through which I can send email to my team mail id. Actually there are number of procedures running daily in our system. So I want to send the status of each procedure means if procedure is getting success,failed or running. If the procedure is in running state...

Biswa9215 pointsBadges:

Exit a macro from inside a macro (iSeries AS/400)

How do I exit a macro while it is running if it runs into an error in iSeries AS/400? I have script that checks to see if the cursor is in a specific position and if it isn't I have a message box pop up telling the user to stop the macro, but how do I have it just exit instead?

jasunderland15 pointsBadges:

SQL Join keeps failing

Hello everyone, This question comes from one of our power users: ToddN2000. I'm trying to join 2 tables and it keeps failing. I did not create the tables and I cannot change them. One has the order defined as NUMERIC(8) the other has the order defined VARCHAR(15). I have tried using CAST, CONVERT,...

Michael Tidmarsh62,135 pointsBadges:

Water coming the Wi-Fi router

Why is water coming from my Wi-Fi router after every 7 days?

lucifer1001200255 pointsBadges:

Print pages batch wise

How can pages be printed batch wise?

Gihankehelella5 pointsBadges:

Performance issue if we have server with disks of varying capacity on iSeries server

Will there be performance issue if we have server with disks of varying capacity on iSeries server?

JohnsonMumbai1,480 pointsBadges:

Error opening MS Outlook

Hello !!!! I'm having a problem when opening the MS Outlook program this error occurs : "Cannot start Microsoft Outlook. Errors in the file ....outlook.pst" is it Possible any way to cure the file ? Thanks in advance .

crowned5 pointsBadges:

Outlook IMAP account says it has closed the connection

A few months ago, I changed my Outlook email from a POP3 account to an IMAP account. But now, I keep getting this error message saying that IMAP has closed the connection. I'm on Windows 10. It looks like my settings are correct too. What should I do?

ITKE1,067,535 pointsBadges:

My phone has been hacked

How can I removed the hacker and prove it? I have change device more than 2 times and it gets hacked every time.

Andresruiz5 pointsBadges:

Quality Assurance in the organization chart

I understand there is not a "one size fits all" for this question but I am curious as how other companies have their Quality Assurance Manager reporting structure set up. Is it to the Operations Manager who oversees all contact center managers or is it for the Director of the center. Or another...

jerrylowe5 pointsBadges:

Microsoft Excel GROUP BY

How can I list the departments and the number of employees in each department?

rajeshwari95 pointsBadges:

System i Navigator will not start

System i Navigator will not start. My Event Viewer indicates that MSVCR80.DLL has errored out. I have already tried repairing and removing Client Access with no results. Here is the event data: Log Name: Application Source: Application Error Date: 8/19/2017 8:18:21 PM Event ID: 1000 Task Category:...

DDEFILLIPO5 pointsBadges:

Change picture caption in Microsoft Word 2010

So, here's my question. I'm trying to caption multiple images in a Word 2010 document. I want them as Figure 1, Figure 2, Figure 3, etc. But when I try, it keeps captioning each image as Figure 1. How can I fix this? Can anyone help?

ITKE1,067,535 pointsBadges:

Remove first heading page number in Microsoft Word 2016

I have a Microsoft Word 2016 document that has a table of contents. Each page has a heading page number at the top. I would like to remove the first heading page (basically - the number '1'). How can I do that and leave the remaining numbers?

ITKE1,067,535 pointsBadges:

Seat calculation in call center

If I have to put 400 agents for 9 hour shift in two different shifts that is 9-6 and 11-8 in which 60% attendance is for 9-6, then how many system I will need?

Sachujidhankhar5 pointsBadges:

Error message when shutting down Windows 10 laptop

Whenever I try to shutdown my Windows 10 laptop, I keep getting this error message: Instruction at referenced memory could not be read. It's happening almost every single time. I can't find anything to resolve this. What can I do?

ITKE1,067,535 pointsBadges:

My inbox emails is increasing

I cannot open them. They do not appear in my inbox. Nevertheless the number of emails is increasing each day. What the hell is going on?

silvianaggiar5 pointsBadges:

AS/400 screen display

How do we change the screen's display? The top of the screen shows "Session A [24 x 80]. We need to be able to show more of the information that resides well to the right of the display. The only way we can view that info is to do a "print screen" and paste to Word. We'd like to be able to view all...

BERNDPAULHANS0 pointsBadges:

AS/400 entire system back up

Below are the steps, I am taking for entire system back up: Initialise tape End all subsystems Go Save-> 21 Now question comes, how to make your system up again after above steps?

ayushgarg185 pointsBadges:

Boot up problem

After I log in, I get a message preparing windows. Later it says can't log on. Logout and log back in. This doesn't work. If I hit dismiss, I lose most of my desktop icons.

virgisplace15 pointsBadges: