Solved

Display a Windows message box from a Oracle PL/SQL package

Posted on 2006-06-13
5
2,651 Views
Last Modified: 2008-01-09
We have an Oracle database, that we want to build a PL/SQL package in, that will notify the user whether or not they have done their time entry for the day, via a windows message box displayed to their screen at 2 PM each day.  Can an Oracle PL/SQL package do this?

Thanks.
0
Comment
Question by:dkbailey1
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
MohanKNair earned 500 total points
ID: 16893203
PL/SQL is a back-end programming language. It can communicate only with other Oracle sessions or with the Oracle client programs.

To buid an alerting mechanism using Windows that works at 2pm each day, it is better to write a client utility that connects to Oracle.
0
 

Author Comment

by:dkbailey1
ID: 16893221
Do you know if a scheduled webpage can send window messages to various users from the webserver?
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 16893277
Using PL/SQL it is possible to send E-Mail to all users using UTL_SMTP package. I don't know whether this will help.

Using PL/SQL server pages it is possible to invoke SP's from a WEB page.

I am not sure whether a WEB page can be programmed to do messaging in windows.

0
 

Author Comment

by:dkbailey1
ID: 16893321
It seems my two choices are to build a webpage that sends an email to each user reminding them to enter their time, or have a webpage on each user's machine that uses the Task Scheduler, where the webpage connects to the database, and then uses javascript that displays a message box to the user reminding them to enter their time.  Could such a webpage be 'hidden' or executed in the 'background' so that the user never sees the webpage, only the message window?
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 16893351
This task involves programming using  some language. Post the same question in Programming section.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Connection String for Oracle database is not working 22 135
history tablespace temp usage 2 39
Oracle sql query 7 60
SQL Developer 6 48
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question