Calling Stored Procedures from PHP :
According to the behavior of SQL statement,you use the statement under PHP codes and make a call to the procedure.You will nest the calls between the BEGIN ... END block which is also known as Anonymous block.
Like :
<?php
// etc.
$sql = 'BEGIN Computer_data(:Order_count, :Values_Rs); END;';
This statement will bind the variables with the PHP variables with calls to oci_bind_by_name().
If the sayHello procedure was defined by the following DDL statement:
Code:
CREATE OR REPLACE PROCEDURE
Computer_data (order_count IN INTEGER, Values_Rs OUT INTEGER)
AS
BEGIN
Values_Rs := 2,12000 || Order_count;
END;
/
Bookmarks