• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2904
  • Last Modified:

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

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
dkbailey1
Asked:
dkbailey1
  • 3
  • 2
1 Solution
 
MohanKNairCommented:
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
 
dkbailey1Author Commented:
Do you know if a scheduled webpage can send window messages to various users from the webserver?
0
 
MohanKNairCommented:
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
 
dkbailey1Author Commented:
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
 
MohanKNairCommented:
This task involves programming using  some language. Post the same question in Programming section.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now