calling servlet and PHP from oracle

[JJJ Kapoor]

hi

I want to call a java servlet and a PHP file fro with in the oracle database trigger.

I also want to execute a stroed procedure at fix time. e.g after each 35 minutes. or at every 9:30Am . Please do help me.

[Jeanne Boyarsky]

I want to call a java servlet and a PHP file fro with in the oracle database trigger.

I don't think you can do this. A trigger can only execute code in the database.

I also want to execute a stroed procedure at fix time. e.g after each 35 minutes. or at every 9:30Am . Please do help me.

You could use a cron job on UNIX (or a task in Windows scheduler) to kick of the stored procedure. The cron job would call a script or JDBC to run the stored procedure.

[Avi Abrami]

Kapoor,
I just answered this very same question that you asked in the "Servlets" forum. However, you didn't mention the requirement to execute a stored procedure at regular intervals.

For your information (and Jeanne's), from Oracle version 8i, the DBMS_JOB package can be used to achieve this. Please see the "Supplied PL/SQL Packages and Types Reference" in the Oracle documentation, which is available online from Oracle's Tahiti Web site.

Good Luck,
Avi.