Content-type: text/html
X-Powered-By: PHP/4.3.8
<html>
<title>ADODB Testing</title>
<body bgcolor=white>
<H1>ADODB Test</H1>
This script tests the following databases: Interbase, Oracle, Visual FoxPro, Microsoft Access (ODBC and ADO), MySQL, MSSQL (ODBC, native, ADO).
There is also support for Sybase, PostgreSQL.</p>
For the latest version of ADODB, visit <a href=http://adodb.sourceforge.net/>adodb.sourceforge.net</a>.</p>
Test <a href=test4.php>GetInsertSQL/GetUpdateSQL</a>
<a href=testsessions.php>Sessions</a>
<a href=testpaging.php>Paging</a>
<a href=test-perf.php>Perf Monitor</a><p>
<table><tr valign=top><td>
<form method=get>
<input type=checkbox name="testaccess" value=1 > <b>Access</b><br>
<input type=checkbox name="testibase" value=1 > <b>Interbase</b><br>
<input type=checkbox name="testmssql" value=1 > <b>MSSQL</b><br>
<input type=checkbox name="testmysql" value=1 > <b>MySQL</b><br>
<input type=checkbox name="testmysqlodbc" value=1 > <b>MySQL ODBC</b><br>
<input type=checkbox name="testmysqli" value=1 > <b>MySQLi</b>
<br>
<td><input type=checkbox name="testsqlite" value=1 > <b>SQLite</b><br>
<input type=checkbox name="testproxy" value=1 > <b>MySQL Proxy</b><br>
<input type=checkbox name="testoracle" value=1 checked> <b>Oracle (oci8)</b> <br>
<input type=checkbox name="testpostgres" value=1 > <b>PostgreSQL</b><br>
<input type=checkbox name="testpgodbc" value=1 > <b>PostgreSQL ODBC</b><br>
<td>
<input type=checkbox name="testpdopgsql" value=1 > <b>PgSQL PDO</b><br>
<input type=checkbox name="testpdomysql" value=1 > <b>MySQL PDO</b><br>
<input type=checkbox name="testpdosqlite" value=1 > <b>SQLite PDO</b><br>
<input type=checkbox name="testpdoaccess" value=1 > <b>Access PDO</b><br>
<td><input type=checkbox name="testdb2" value=1 > DB2<br>
<input type=checkbox name="testvfp" value=1 > VFP+ODBTP<br>
<input type=checkbox name="testado" value=1 > ADO (for mssql and access)<br>
<input type=checkbox name="nocountrecs" value=1 > $ADODB_COUNTRECS=false<br>
<input type=checkbox name="nolog" value=1 > No SQL Logging<br>
<input type=checkbox name="time" value=1 > ADOdb time test
</table>
<input type=submit>
</form>
<h1>Connecting oci8po...</h1> <form method=GET>
</p>
<table width=100% ><tr><td bgcolor=beige> </td></tr></table>
</p>
<h3>SQL Logging enabled</h3><h3>ADODB Version: V4.81 3 May 2006 (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved. Released BSD & LGPL. Host: <i>sherkhan</i> Database: <i></i> PHP: 4.3.8 </h3>Array
(
[compat] => 9.2.0.0.0
[description] => Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
[version] => 9.2.0.1.0
)
<br><br>db->Time: 19-05-2005 11:44:42<br>Date=2002-04-07<br><i>date1</i> (1969-02-20) = TO_DATE('1969-02-20','YYYY-MM-DD')<br><i>date1</i> (1999-02-20) = TO_DATE('1999-02-20','YYYY-MM-DD')<br><i>date1.1</i> 1999 = TO_DATE('2005-05-19','YYYY-MM-DD')<br><i>date2</i> (1970-1-2) = TO_DATE('1970-01-02','YYYY-MM-DD')<p><i>ts1</i> (1999-02-20 13:40:50) = TO_DATE('1999-02-20, 01:40:50 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts1.1</i> (1999-02-20 13:40:00) = TO_DATE('1999-02-20, 01:04:00 PM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts2</i> (1999-02-20) = TO_DATE('1999-02-20, 12:00:00 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts3</i> (1970-1-2 +/- timezone) = TO_DATE('1970-01-02, 08:00:00 AM','RRRR-MM-DD, HH:MI:SS AM')<br> Fractional TS (1999-2-20 13:40:50.91): TO_DATE('1999-02-20, 01:40:50 PM','RRRR-MM-DD, HH:MI:SS AM')<br>unixdate</i> 1999-02-20 = 1999-02-20<p><br><i>ts4</i> =61<br><i>ts5</i> =TO_DATE('2004-01-10, 09:21:23 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts6</i> =2004-01-10 09:21:23<br><i>ts7</i> =TO_DATE('2004-01-10, 09:21:23 AM','RRRR-MM-DD, HH:MI:SS AM')<p>Test select on empty table, FetchField when EOF, and GetInsertSQL</p><p>Testing Commit: OK</p><p>Testing Rollback: OK</p><p>Testing MetaDatabases()</p>AAArray
(
[0] => ANONYMOUS
[1] => CTXSYS
[2] => DEV
[3] => HR
[4] => IOU
[5] => JURIS10
[6] => JURIS9
[7] => MDSYS
[8] => ODB
[9] => ODB2
[10] => ODM
[11] => ODM_MTR
[12] => OE
[13] => OLAPSYS
[14] => ORDPLUGINS
[15] => ORDSYS
[16] => PM
[17] => QS
[18] => QS_ADM
[19] => QS_CB
[20] => QS_CBADM
[21] => QS_CS
[22] => QS_ES
[23] => QS_OS
[24] => QS_WS
[25] => RMAN
[26] => SCOTT
[27] => SH
[28] => SONY
[29] => TOAD
[30] => WKPROXY
[31] => WKSYS
[32] => WMSYS
[33] => XDB
)
<p>Testing MetaTables() and MetaColumns()</p>AAArray of tables and views: (abalone2) (abalone2_tree_jl1) (abalone_tree) (address) (adodb_logsql) (adoxyz) (alertrx) (atest) (billdet) (billhdr) (binlist) (cache_jorg_121) (cache_jorg_127) (contact) (create$java$lob$table) (diary) (diary2) (dlagent) (dlagentactivity) (dlagentcampaign) (dlagentcampaignvw) (dlagentcurrentstatus) (dlagenthistory) (dlagentshift) (dlagentstats) (dlagent_collection) (dlcallhistory) (dlcampaign) (dlcampaignactivity) (dlcampaignset) (dlcampaignshift) (dlcampaign_collection) (dlkbagentstatus) (dlkbarea) (dlkbgroup) (dlkbliststatus) (dlkbmedia) (dlkboutcome) (dlkbshift) (dlkbskill) (dlkbstagevw) (dlkbstatus) (dlkbtype) (dlkbvw) (dllist) (dllisterror) (dllistsource) (dllisttemp) (dlmessage) (dlteam) (dltimedcampaignactivity) (dltrafficreport) (employee) (emp_pay_hist) (emp_perf_hist) (emp_perf_plan) (endorser) (exchange) (fclsdatextra) (fclsfacreln) (fclskb) (fclskbcatvals) (fclskbexpiry) (fclskbfacreln) (fclskbprop) (fclskbstage) (fclskbstep) (fclskbstgroup) (fclssec) (fclssecrole) (fclsstepdate) (germall) (germall_cluster) (germall_range) (germall_rules) (germall_tree) (glass) (glass_tree) (ivr) (ivrcall) (ivrcca) (ivrevents) (ivrservice) (ivr_by_hour) (ivr_by_hours) (ivr_cat) (ivr_defaults) (ivr_demo) (ivr_dim) (ivr_map) (ivr_map_hours) (ivr_rp) (ivr_tmp_demo) (java$class$md5$table) (java$options) (jcampaign) (jcasemast) (jclnt) (jclntbrch) (jclntdept) (jclntdiv) (jcontact) (jcustomer) (jdefaults) (jdiary) (jfacility) (jfirm) (jfirmbrch) (jfirmdiv) (jmail) (jmail_x) (job_market_data) (jopportunity) (jorg) (jstate) (jstepprint) (jsurvey) (jtask) (jtaskitem) (kb) (kbactivity) (kbarea) (kbcatvals) (kbcountry) (kbcurrency) (kbdomain_juris10) (kbdomain_tiger2) (kbjob) (kbjobrating) (kblang) (kbmedia) (kbproductivity) (kbq) (kbqset) (kbqstatus) (kbregion) (kbrole) (kbskill) (kbstage) (kbstatus) (kbstep) (kbsteptype) (kbsubdomain) (kbworkarea) (kbworknode) (kutu_testtable) (lens_columns) (lens_groups) (lens_log) (lens_logurl) (lens_perms) (lens_rank) (lens_users) (lens_users_collection) (lens_users_x) (mcc) (myarn) (mycard) (oldkbstage) (oldkbstep) (old_ivr_by_hour) (pay_budget_hist) (pay_budget_plan) (photos) (phplens) (phplens_lock) (plan_table) (products) (qhist) (qlog) (qsetreport) (qtest) (qtest_len) (q_1005) (q_1006) (q_1008) (q_1010) (q_1011) (q_1016) (q_1017) (q_1018) (q_1019) (q_1020) (q_1021) (q_1022) (q_1023) (q_1024) (reseller) (review_period) (role) (ruledet) (splist) (tempname) (tennis) (tennis_tree) (toad_plan_table) (transact) (transact_040321) (transalert) (transalert_22) (transrule) (vt) (vwaddress) (vwcasecontact) (vwcaserolefacreln) (vwdiary_diary2) (vwfclsfacreln_contact) (vwfclssec_fclssecrole) (vwreview_search) (vwstepdatextra) (vwtransact) (vwtransalert) (xaddress) (xcase) (xcasevvv) (xcontact) (xcurstep) (xdiary) (xfirm) (xmonitor) (xrole) (xsummstatustmp) (xx) </p>AAArray of views: (address) (contact) (dlagentcampaignvw) (dlkbstagevw) (dlkbvw) (ivr) (ivr_by_hours) (ivr_map_hours) (products) (role) (vt) (vwaddress) (vwcasecontact) (vwcaserolefacreln) (vwdiary_diary2) (vwfclsfacreln_contact) (vwfclssec_fclssecrole) (vwreview_search) (vwstepdatextra) (vwtransact) (vwtransalert) (xcasevvv) (xdiary) (xfirm) </p>AAArray of ado%: (adoxyz) </p>AAArray of tables: (abalone2) (abalone2_tree_jl1) (abalone_tree) (adodb_logsql) (adoxyz) (alertrx) (atest) (billdet) (billhdr) (binlist) (cache_jorg_121) (cache_jorg_127) (create$java$lob$table) (diary) (diary2) (dlagent) (dlagentactivity) (dlagentcampaign) (dlagentcurrentstatus) (dlagenthistory) (dlagentshift) (dlagentstats) (dlagent_collection) (dlcallhistory) (dlcampaign) (dlcampaignactivity) (dlcampaignset) (dlcampaignshift) (dlcampaign_collection) (dlkbagentstatus) (dlkbarea) (dlkbgroup) (dlkbliststatus) (dlkbmedia) (dlkboutcome) (dlkbshift) (dlkbskill) (dlkbstatus) (dlkbtype) (dllist) (dllisterror) (dllistsource) (dllisttemp) (dlmessage) (dlteam) (dltimedcampaignactivity) (dltrafficreport) (employee) (emp_pay_hist) (emp_perf_hist) (emp_perf_plan) (endorser) (exchange) (fclsdatextra) (fclsfacreln) (fclskb) (fclskbcatvals) (fclskbexpiry) (fclskbfacreln) (fclskbprop) (fclskbstage) (fclskbstep) (fclskbstgroup) (fclssec) (fclssecrole) (fclsstepdate) (germall) (germall_cluster) (germall_range) (germall_rules) (germall_tree) (glass) (glass_tree) (ivrcall) (ivrcca) (ivrevents) (ivrservice) (ivr_by_hour) (ivr_cat) (ivr_defaults) (ivr_demo) (ivr_dim) (ivr_map) (ivr_rp) (ivr_tmp_demo) (java$class$md5$table) (java$options) (jcampaign) (jcasemast) (jclnt) (jclntbrch) (jclntdept) (jclntdiv) (jcontact) (jcustomer) (jdefaults) (jdiary) (jfacility) (jfirm) (jfirmbrch) (jfirmdiv) (jmail) (jmail_x) (job_market_data) (jopportunity) (jorg) (jstate) (jstepprint) (jsurvey) (jtask) (jtaskitem) (kb) (kbactivity) (kbarea) (kbcatvals) (kbcountry) (kbcurrency) (kbdomain_juris10) (kbdomain_tiger2) (kbjob) (kbjobrating) (kblang) (kbmedia) (kbproductivity) (kbq) (kbqset) (kbqstatus) (kbregion) (kbrole) (kbskill) (kbstage) (kbstatus) (kbstep) (kbsteptype) (kbsubdomain) (kbworkarea) (kbworknode) (kutu_testtable) (lens_columns) (lens_groups) (lens_log) (lens_logurl) (lens_perms) (lens_rank) (lens_users) (lens_users_collection) (lens_users_x) (mcc) (myarn) (mycard) (oldkbstage) (oldkbstep) (old_ivr_by_hour) (pay_budget_hist) (pay_budget_plan) (photos) (phplens) (phplens_lock) (plan_table) (qhist) (qlog) (qsetreport) (qtest) (qtest_len) (q_1005) (q_1006) (q_1008) (q_1010) (q_1011) (q_1016) (q_1017) (q_1018) (q_1019) (q_1020) (q_1021) (q_1022) (q_1023) (q_1024) (reseller) (review_period) (ruledet) (splist) (tempname) (tennis) (tennis_tree) (toad_plan_table) (transact) (transact_040321) (transalert) (transalert_22) (transrule) (xaddress) (xcase) (xcontact) (xcurstep) (xmonitor) (xrole) (xsummstatustmp) (xx) </p>-----
(oci8po): select lower(cname), coltype, width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='ADOXYZ' order by colno
-----
AA<p>Columns of ADOXYZ: <font size=1><br>adofieldobject Object
(
[name] => firstname
[max_length] => 24
[type] => VARCHAR2
[scale] =>
[not_null] =>
[binary] =>
[default_value] =>
)
<br>adofieldobject Object
(
[name] => lastname
[max_length] => 24
[type] => VARCHAR2
[scale] =>
[not_null] =>
[binary] =>
[default_value] =>
)
<br>adofieldobject Object
(
[name] => created
[max_length] => 7
[type] => DATE
[scale] =>
[not_null] =>
[binary] =>
[default_value] =>
)
<br></font><p>Testing MetaIndexes</p>-----
(oci8po): SELECT * FROM ALL_CONSTRAINTS WHERE UPPER(TABLE_NAME)='ADOXYZ' AND CONSTRAINT_TYPE='P'
-----
AA<b>MetaIndexes not supported</b></p><p>Testing MetaPrimaryKeys</p>-----
(oci8po):
SELECT /*+ RULE */ distinct b.column_name
FROM USER_CONSTRAINTS a
, USER_CONS_COLUMNS b
WHERE ( UPPER(b.table_name) = ('ADOXYZ'))
AND (UPPER(a.table_name) = ('ADOXYZ') and a.constraint_type = 'P')
AND (a.constraint_name = b.constraint_name)
-----
bool(false)
-----
(oci8po): delete from ADOXYZ
-----
InParameter($stmt, $php_var='99', $name='id', $maxLen=4000, $type=false);
Bind: name = id
InParameter($stmt, $php_var='123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', $name='xx', $maxLen=-1, $type=113);
Bind: name = xx
Bind: descriptor has been allocated, var (xx) binded
Bind: LOB has been written to temp
-----
(oci8po): INSERT INTO photos ( ID, photo) VALUES ( :id, empty_blob() ) RETURNING photo INTO :xx
-----
IN LOB: LOB has been saved.
Smart Commit occurred
-----
(oci8po): select photo from photos where id=99
-----
<br>---123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890<h4>Testing Blob: size=5010</h4>-----
(oci8po): UPDATE photos set photo=EMPTY_BLOB() WHERE id=1 RETURNING photo INTO ?
-----
name=:blob var=Object len=-1 type=113<br>-----
(oci8po): select photo from photos where id=1
-----
<h4>Testing Clob: size=5010</h4>-----
(oci8po): UPDATE photos set descclob=EMPTY_CLOB() WHERE id=1 RETURNING descclob INTO ?
-----
name=:blob var=Object len=-1 type=112<br>-----
(oci8po): select descclob from photos where id=1
-----
<h4>Testing Foreign Keys</h4>-----
(oci8po): select constraint_name, r_owner, r_constraint_name
from user_constraints
where constraint_type = 'R' and table_name = 'EMP' and owner='JURIS10'
-----
AA<b>Bad MetaForeignKeys</b><br><h4>Testing Cursor Variables</h4>InParameter($stmt, $php_var='', $name='zz', $maxLen=-1, $type=116);
-----
(oci8po): BEGIN adodb.open_tab(:zz, 'A%'); END;
-----
-----
(oci8po): SELECT count(*) FROM tab where tname like 'A%'
-----
Test 1 RowCount: OK<p><h4>Testing Stored Procedures for oci8</h4>InParameter($stmt, $php_var='Malaysia', $name='a1', $maxLen=4000, $type=false);
Bind: name = a1
OutParameter($stmt, $php_var='', $name='a2', $maxLen=4000, $type=false);
Bind: name = a2
-----
(oci8po): BEGIN adodb.data_out(:a1, :a2); END;
-----
OK: a2=Cinta Hati Malaysia<p>InParameter($stmt, $php_var='A%', $name='tablename', $maxLen=4000, $type=false);
Bind: name = tablename
-----
(oci8po): select * from tab where tname like :tablename
-----
<TABLE COLS=3 BORDER='1' WIDTH='98%'><tr>
<TH>tname</TH><TH>tabtype</TH><TH>clusterid</TH>
</tr>
<TR valign=top>
<TD>ABALONE</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ABALONE2</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ABALONE2_TREE_JL1</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ABALONE_TREE</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ADDRESS</TD>
<TD>VIEW</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ADODB_LOGSQL</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ADOXYZ</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ALERTRX</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
<TR valign=top>
<TD>ATEST</TD>
<TD>TABLE</TD>
<TD align=right> </TD>
</TR>
</TABLE>
InParameter($stmt, $php_var='Malaysia', $name='a1', $maxLen=4000, $type=false);
Bind: name = a1
-----
(oci8po): begin adodb.data_in(:a1); end;
-----
<p>Testing Bulk Insert of 3 rows</p>-----
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
-----
Smart Commit occurred
-----
(oci8po): select * from ADOXYZ order by id
-----
<TABLE COLS=4 BORDER='1' WIDTH='98%'><tr>
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH>
</tr>
<TR valign=top>
<TD align=right>1 </TD>
<TD>Caroline</TD>
<TD>Miranda</TD>
<TD> </TD>
<TD> </TD>
</TR>
<TR valign=top>
<TD align=right>2 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD> </TD>
<TD> </TD>
</TR>
<TR valign=top>
<TD align=right>3 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD> </TD>
<TD> </TD>
</TR>
</TABLE>
-----
(oci8po): delete from ADOXYZ
-----
<p>Inserting 50 rows</p>-----
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (0*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (1*10+0, :0, :1, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (2*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (3*10+0, :0, :1, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
-----
-----
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (4*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
-----
-----
(oci8po): select count(*) from ADOXYZ
-----
-----
(oci8po): update ADOXYZ set id=id+1
-----
<p>Affected_Rows() passed</p>-----
(oci8po): select id from ADOXYZ
where id=? and created>=?
-----
<br>Bind date/integer passedBB<p><b>RecordCount returns 49</b></p><p><b>PO_RecordCount returns wrong value: 49</b></p><b><p>The fields columns <i>cannot</i> be indexed by column name.</p></b><br>Array
(
[ID] => 2
[FIRSTNAME] => John
[LASTNAME] => Lim
[CREATED] => 2005-05-19
[ABS(MOD(DBMS_RANDOM.RANDOM,10000001)/10000000)] => .0233416
)
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
</tr>
<TR valign=top>
<TD align=right>2 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.0233416 </TD>
</TR>
<TR valign=top>
<TD align=right>3 </TD>
<TD>Mary</TD>
<TD>Lamb</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.1240054 </TD>
</TR>
<TR valign=top>
<TD align=right>4 </TD>
<TD>George</TD>
<TD>Washington</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.590735 </TD>
</TR>
<TR valign=top>
<TD align=right>5 </TD>
<TD>Mr. Alan</TD>
<TD>Tam</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6431706 </TD>
</TR>
<TR valign=top>
<TD align=right>6 </TD>
<TD>Alan</TD>
<TD>Turing'ton</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.1579551 </TD>
</TR>
<TR valign=top>
<TD align=right>7 </TD>
<TD>Serena</TD>
<TD>Williams</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.5652993 </TD>
</TR>
<TR valign=top>
<TD align=right>8 </TD>
<TD>Yat Sun</TD>
<TD>Sun</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8400974 </TD>
</TR>
<TR valign=top>
<TD align=right>9 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8073812 </TD>
</TR>
<TR valign=top>
<TD align=right>10 </TD>
<TD>Steven</TD>
<TD>Oey</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.1340615 </TD>
</TR>
<TR valign=top>
<TD align=right>11 </TD>
<TD>Caroline</TD>
<TD>Miranda</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.9993386 </TD>
</TR>
<TR valign=top>
<TD align=right>12 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.7807507 </TD>
</TR>
<TR valign=top>
<TD align=right>13 </TD>
<TD>Mary</TD>
<TD>Lamb</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.1983442 </TD>
</TR>
<TR valign=top>
<TD align=right>14 </TD>
<TD>George</TD>
<TD>Washington</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.9449505 </TD>
</TR>
<TR valign=top>
<TD align=right>15 </TD>
<TD>Mr. Alan</TD>
<TD>Tam</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.5663581 </TD>
</TR>
<TR valign=top>
<TD align=right>16 </TD>
<TD>Alan</TD>
<TD>Turing'ton</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.4669657 </TD>
</TR>
<TR valign=top>
<TD align=right>17 </TD>
<TD>Serena</TD>
<TD>Williams</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6451908 </TD>
</TR>
<TR valign=top>
<TD align=right>18 </TD>
<TD>Yat Sun</TD>
<TD>Sun</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.4639599 </TD>
</TR>
<TR valign=top>
<TD align=right>19 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.4443077 </TD>
</TR>
<TR valign=top>
<TD align=right>20 </TD>
<TD>Steven</TD>
<TD>Oey</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.3388362 </TD>
</TR>
<TR valign=top>
<TD align=right>21 </TD>
<TD>Caroline</TD>
<TD>Miranda</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8143343 </TD>
</TR>
</TABLE>
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
</tr><TR valign=top>
<TD align=right>22 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.972867 </TD>
</TR>
<TR valign=top>
<TD align=right>23 </TD>
<TD>Mary</TD>
<TD>Lamb</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.5805857 </TD>
</TR>
<TR valign=top>
<TD align=right>24 </TD>
<TD>George</TD>
<TD>Washington</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.0551489 </TD>
</TR>
<TR valign=top>
<TD align=right>25 </TD>
<TD>Mr. Alan</TD>
<TD>Tam</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.0705427 </TD>
</TR>
<TR valign=top>
<TD align=right>26 </TD>
<TD>Alan</TD>
<TD>Turing'ton</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.4666325 </TD>
</TR>
<TR valign=top>
<TD align=right>27 </TD>
<TD>Serena</TD>
<TD>Williams</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.7516632 </TD>
</TR>
<TR valign=top>
<TD align=right>28 </TD>
<TD>Yat Sun</TD>
<TD>Sun</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.3328669 </TD>
</TR>
<TR valign=top>
<TD align=right>29 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8351005 </TD>
</TR>
<TR valign=top>
<TD align=right>30 </TD>
<TD>Steven</TD>
<TD>Oey</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2147344 </TD>
</TR>
<TR valign=top>
<TD align=right>31 </TD>
<TD>Caroline</TD>
<TD>Miranda</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8954723 </TD>
</TR>
<TR valign=top>
<TD align=right>32 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.3072688 </TD>
</TR>
<TR valign=top>
<TD align=right>33 </TD>
<TD>Mary</TD>
<TD>Lamb</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2168223 </TD>
</TR>
<TR valign=top>
<TD align=right>34 </TD>
<TD>George</TD>
<TD>Washington</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2349472 </TD>
</TR>
<TR valign=top>
<TD align=right>35 </TD>
<TD>Mr. Alan</TD>
<TD>Tam</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.5354307 </TD>
</TR>
<TR valign=top>
<TD align=right>36 </TD>
<TD>Alan</TD>
<TD>Turing'ton</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.4541119 </TD>
</TR>
<TR valign=top>
<TD align=right>37 </TD>
<TD>Serena</TD>
<TD>Williams</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6528771 </TD>
</TR>
<TR valign=top>
<TD align=right>38 </TD>
<TD>Yat Sun</TD>
<TD>Sun</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.5078207 </TD>
</TR>
<TR valign=top>
<TD align=right>39 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2280108 </TD>
</TR>
<TR valign=top>
<TD align=right>40 </TD>
<TD>Steven</TD>
<TD>Oey</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.0865263 </TD>
</TR>
<TR valign=top>
<TD align=right>41 </TD>
<TD>Caroline</TD>
<TD>Miranda</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.866602 </TD>
</TR>
</TABLE>
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
</tr><TR valign=top>
<TD align=right>42 </TD>
<TD>John</TD>
<TD>Lim</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6110876 </TD>
</TR>
<TR valign=top>
<TD align=right>43 </TD>
<TD>Mary</TD>
<TD>Lamb</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.0870814 </TD>
</TR>
<TR valign=top>
<TD align=right>44 </TD>
<TD>George</TD>
<TD>Washington</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.8348281 </TD>
</TR>
<TR valign=top>
<TD align=right>45 </TD>
<TD>Mr. Alan</TD>
<TD>Tam</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2111793 </TD>
</TR>
<TR valign=top>
<TD align=right>46 </TD>
<TD>Alan</TD>
<TD>Turing'ton</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2265778 </TD>
</TR>
<TR valign=top>
<TD align=right>47 </TD>
<TD>Serena</TD>
<TD>Williams</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6451763 </TD>
</TR>
<TR valign=top>
<TD align=right>48 </TD>
<TD>Yat Sun</TD>
<TD>Sun</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.6077789 </TD>
</TR>
<TR valign=top>
<TD align=right>49 </TD>
<TD>Wai Hun</TD>
<TD>See</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.1526813 </TD>
</TR>
<TR valign=top>
<TD align=right>50 </TD>
<TD>Steven</TD>
<TD>Oey</TD>
<TD>Thu 19, May 2005 </TD>
<TD align=right>.2569144 </TD>
</TR>
</TABLE>
<p>GetOne returns ok</p><p>GetRow returns ok</p><p>FetchObject/FetchNextObject Test</p>AA<p>FetchObject/FetchNextObject Test 2</p>BBArray
(
[ID] => 4
[FIRSTNAME] => George
[LASTNAME] => Washington
[CREATED] => 2005-05-19
)
<br />
<b>Notice</b>: Undefined index: id in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
<br />
<b>Notice</b>: Undefined index: firstname in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
<br />
<b>Notice</b>: Undefined index: lastname in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
<br />
<b>Notice</b>: Undefined index: created in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
adofetchobj Object
(
[ID] =>
[FIRSTNAME] =>
[LASTNAME] =>
[CREATED] =>
)
<p><b>Firstname is not string</b></p><p>CacheSelectLimit Test</p> /tmp/0d/adodb_0d16f79a74ee76ccabfb86ca1945f9ad.cache reloaded, ttl=2913 [ select * from (SELECT /*+FIRST_ROWS*/ id, firstname from ADOXYZ order by id) where rownum