Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
a.mdb	1.96 MB	-rwxr-xr-x
benchmark.php	2.03 KB	-rwxr-xr-x
client.php	3.99 KB	-rwxr-xr-x
pdo.php	1.73 KB	-rwxr-xr-x
test-active-record.php	2.28 KB	-rwxr-xr-x
test-active-recs2.php	1.39 KB	-rwxr-xr-x
test-datadict.php	7.44 KB	-rwxr-xr-x
test-perf.php	909 B	-rwxr-xr-x
test-pgblob.php	1.99 KB	-rwxr-xr-x
test-php5.php	2.48 KB	-rwxr-xr-x
test-xmlschema.php	1.28 KB	-rwxr-xr-x
test.php	54.17 KB	-rwxr-xr-x
test2.php	573 B	-rwxr-xr-x
test3.php	896 B	-rwxr-xr-x
test4.php	4.56 KB	-rwxr-xr-x
test5.php	1.35 KB	-rwxr-xr-x
test_rs_array.php	679 B	-rwxr-xr-x
testcache.php	806 B	-rwxr-xr-x
testdatabases.inc.php	17.49 KB	-rwxr-xr-x
testgenid.php	731 B	-rwxr-xr-x
testmssql.php	1.99 KB	-rwxr-xr-x
testoci8.php	2.31 KB	-rwxr-xr-x
testoci8cursor.php	2.9 KB	-rwxr-xr-x
testpaging.php	2.26 KB	-rwxr-xr-x
testpear.php	873 B	-rwxr-xr-x
testsessions.php	2.08 KB	-rwxr-xr-x
time.php	520 B	-rwxr-xr-x
tmssql.php	1.84 KB	-rwxr-xr-x
xmlschema-mssql.xml	832 B	-rwxr-xr-x
xmlschema.xml	961 B	-rwxr-xr-x

Code Editor : testoci8cursor.php

<?php
/* 
V4.80 8 Mar 2006 (c) 2000-2008 John Lim (jlim#natsoft.com.my). All rights reserved.
 Released under both BSD license and Lesser GPL library license. 
 Whenever there is any discrepancy between the two licenses, 
 the BSD license will take precedence. 
 Set tabs to 4 for best viewing.
	
 Latest version is available at http://adodb.sourceforge.net
*/

/*
	Test for Oracle Variable Cursors, which are treated as ADOdb recordsets.
	
	We have 2 examples. The first shows us using the Parameter statement. 
	The second shows us using the new ExecuteCursor($sql, $cursorName)
	function.
	
------------------------------------------------------------------
-- TEST PACKAGE YOU NEED TO INSTALL ON ORACLE - run from sql*plus
------------------------------------------------------------------

-- TEST PACKAGE
CREATE OR REPLACE PACKAGE adodb AS
TYPE TabType IS REF CURSOR RETURN tab%ROWTYPE;
PROCEDURE open_tab (tabcursor IN OUT TabType,tablenames in varchar);
PROCEDURE data_out(input IN varchar, output OUT varchar);

procedure myproc (p1 in number, p2 out number);
END adodb;
/

CREATE OR REPLACE PACKAGE BODY adodb AS
PROCEDURE open_tab (tabcursor IN OUT TabType,tablenames in varchar) IS
	BEGIN
		OPEN tabcursor FOR SELECT * FROM tab where tname like tablenames;
	END open_tab;
	
PROCEDURE data_out(input IN varchar, output OUT varchar) IS
	BEGIN
		output := 'Cinta Hati '||input;
	END;
	
procedure myproc (p1 in number, p2 out number) as
begin
p2 := p1;
end;
END adodb;
/

------------------------------------------------------------------
-- END PACKAGE
------------------------------------------------------------------

include('../adodb.inc.php');
include('../tohtml.inc.php');

error_reporting(E_ALL);
	$db = ADONewConnection('oci8');
	$db->PConnect('','scott','natsoft');
	$db->debug = 99;

/*
*/

define('MYNUM',5);

$rs = $db->ExecuteCursor("BEGIN adodb.open_tab(:RS,'A%'); END;");
	
	if ($rs && !$rs->EOF) {
		print "Test 1 RowCount: ".$rs->RecordCount()."";
	} else {
		print "Error in using Cursor Variables 1";
	}
	
	print "<h4>Testing Stored Procedures for oci8</h4>";
	
	$stid = $db->PrepareSP('BEGIN adodb.myproc('.MYNUM.', :myov); END;');
	$db->OutParameter($stid, $myov, 'myov');
	$db->Execute($stid);
	if ($myov != MYNUM) print "Error with myproc";
	
	
	$stmt = $db->PrepareSP("BEGIN adodb.data_out(:a1, :a2); END;",true);
	$a1 = 'Malaysia';
	//$a2 = ''; # a2 doesn't even need to be defined!
	$db->InParameter($stmt,$a1,'a1');
	$db->OutParameter($stmt,$a2,'a2');
	$rs = $db->Execute($stmt);
	if ($rs) {
		if ($a2 !== 'Cinta Hati Malaysia') print "Stored Procedure Error: a2 = $a2";
		else echo "OK: a2=$a2";
	} else {
		print "Error in using Stored Procedure IN/Out Variables";
	}
	
	
	$tname = 'A%';
	
	$stmt = $db->PrepareSP('select * from tab where tname like :tablename');
	$db->Parameter($stmt,$tname,'tablename');
	$rs = $db->Execute($stmt);
	rs2html($rs);
		
		
?>

${this.title}

Code Editor : testoci8cursor.php