ID:               22586
 Updated by:       [EMAIL PROTECTED]
 Reported By:      steveh at brendata dot co dot uk
-Status:           Open
+Status:           Feedback
 Bug Type:         DBX related
 Operating System: Windows NT4 SP6
 PHP Version:      4.3.1
 New Comment:

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


Does the dbx_query call return? var_dump $result may tell you this...
Did you try a dbx_close on the connection?


Previous Comments:
------------------------------------------------------------------------

[2003-03-07 04:51:21] steveh at brendata dot co dot uk

When the following script is run it produces an execution timeout (30
seconds exceeded), even though the table is actually created.

<?
 function connect(){
// This function handles all connects to the oracle db
$user = "SA";
$pass = "SAPASSWORD";
$db_name = "docdb.brendata";
$link = dbx_connect(DBX_OCI8, "", $db_name, $user, $pass)
         or die("Could not connect");
return $link;
 }

function TableForActions() {
 $Result='create table I_ACTIONS ('.
 'Record varchar2(255)'.
 ',ActivityType varchar2(50)'.
 ',TaskDescription CLOB'.
 ',Document varchar2(50)'.
 ',TargetDate varchar2(20)'.
 ',AffectedProcess varchar2(50)'.
 ',CustomerRequestNumber varchar2(50)'.
 ',ContractManager_LDAP varchar2(50)'.
 ',CustomerNotification varchar2(50)'.
 ',CustomerApproval varchar2(50)'.
 ',CustomerNotificationDate varchar2(20)'.
 ',SalesMarketing_LDAP varchar2(50)'.
 ',SalesMarketingNotification varchar2(50)'.
 ',SalesMarketingNotificationDate varchar2(20)'.
 ',ResponsiblePerson_LDAP varchar2(50)'.
 ',CompletedDate varchar2(20)'.
 ')';
 return $Result; }

$result = dbx_query(connect(),TableForActions());
                                                           ?>


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=22586&edit=1

Reply via email to