?
Solved

Calling PHP script from oracle procedure

Posted on 2012-09-18
4
Medium Priority
?
557 Views
Last Modified: 2012-09-19
Hello,

i have a script written in PHP ... i am running it from linux or windows cmd by entering command:

php.exe script_name.php parameter1 parameter2

Open in new window


I wonder if someone has an example how to implement that script call into an oracle procedure?

Thank you!
0
Comment
Question by:Caruso_eu
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 38408453
0
 

Author Comment

by:Caruso_eu
ID: 38408540
Well to make it clear(er). In sqlplus you can run it like this:

host('c:\php\php.exe e:\script_dir\script.php');

Open in new window


Now what would be same command for database stored procedure?
0
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 2000 total points
ID: 38408645
this is anothe link for excuting command in pracle procedure

http://www.dba-oracle.com/t_execute_operating_system_os_command_oracle.htm
0
 

Author Comment

by:Caruso_eu
ID: 38413652
I've requested that this question be deleted for the following reason:

reopening new one
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month14 days, 8 hours left to enroll

839 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