<div>
I agree that this should probably be scheduled outside the database but since you asked: &nbsp;DBMS_SECHDULER can execute an OS program:<br />
<br />
<a href="http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72260" rel="ugc nofollow">http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72260</a>
</div>


I agree that this should probably be scheduled outside the database but since you asked:  DBMS_SECHDULER can execute an OS program:

http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72260 [http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72260]

<div>
So its doable? I mean i would probably have to install PHP client on linux if i would want to run it with HOST command from my stored procedure?
</div>


So its doable? I mean i would probably have to install PHP client on linux if i would want to run it with HOST command from my stored procedure?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
i am wondering if anyone have tried something similar. I have a PHP script which is fetching data of website and storing it in oracle. This has to be automated somehow.<br />
<br />
So i was wondering if it would be possible to make database procedure and set up a JOB for it and make it run every X time.<br />
<br />
I am running this PHP procedure from CMD on windows with following command:<br />
<br />
php.exe name_of_script.php parameter1 parameter2<br />
<br />
Oracle base 10.0.2 is installed on linux.<br />
<br />
Any ideas?
</div>
</div>


Hello,

i am wondering if anyone have tried something similar. I have a PHP script which is fetching data of website and storing it in oracle. This has to be automated somehow.

So i was wondering if it would be possible to make database procedure and set up a JOB for it and make it run every X time.

I am running this PHP procedure from CMD on windows with following command:

php.exe name_of_script.php parameter1 parameter2

Oracle base 10.0.2 is installed on linux.

Any ideas?

[ORACLE]Stored procedure running PHP script

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.