In this example, a stored function was called by a PHP-Application.

<meta charset="utf-8" />
<title>jQuery_PHP_Qracle Function Editor</title>
<style type="text/css">
html, body { height: 100%; }
.TB2 { border:2px solid navy; color:green; }
.TB1 { border:2px solid green;color: navy;
vertical-align:text-top;width:300px; height:100px;}
.sp1 { width: 450px; height:100px; overflow:auto;color:navy;}
.td1 { width: 60px; height: 10px;background-color:#b0c4de;}
.td2 { width: 60px; height: 20px; font-size:12px;}
.td3 { width: 50px; height: 20px;} </style>
<script src=""></script>
<script type="text/javascript" src="http://manas9/jQuery/jquery-latest.js"></script>
//Code Starts
$(document).ready(function() {
var doc2 = document.getElementById("div3");
$.ajaxSetup({ cache:false});
$("a.RR").click(function (){ location.reload();
$('input[type=textarea]').each(function() {

}); // reload the page

<!-- http://manas8x/BareBone_PHP/Oracle_StoredProc_QueryTool1.php -->
Oracle SQL-Querying-a stored function ||<br/>Using PHP Script
<br/><a class="RR" href="#">re-load()</a>||
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<textarea name="sql" class="TB1" >begin:bv:=CTOF(29.25);END;</textarea><br>
<input type="submit" name="submit" value="Submit Form"><br>
$sql = "";
$sql = $_POST['sql'];
echo "Oracle sql-query <span class='sp1'> <br/>:" . $sql ."</span>";
$conn = oci_connect('hr', 'Son', 'localhost/');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
echo" DB connected: querying a table <br/>";
$stmt = oci_parse($conn, $sql);
oci_bind_by_name($stmt, ":bv", $p1, 6);
$result= oci_execute($stmt);
echo"<br/> Output ..".$p1. ".. end of message<br/>";
echo "<br/> Oracle db connection closed";

Runtime Views:

Change input values, and submit :