Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199807

Re: [PHP3] Strange behavior with Oracle UPDATE From: Richard Lynch (lynch <email protected>)
Date: 07/31/98

I don't know nuthin' 'bout no Oracle, but if adding these lines messes up, I'd try some of the following:

>$conn_id = ora_plogon("user","password");
> ora_CommitOn($conn_id);
> $cur = ora_open($conn_id);

echo("Attempting to Ora_parse<BR>\n");

> ora_parse($cur,"update dbadmin.db_sessions set inc='$inc',
> control='$controlcode',password='$password',acct_type='$acct_type',
>step='$step',acct_region='$acct_region' where session_id='$sessionid'");

echo("Attempting to Ora_exec<BR>\n");

> ora_exec($cur);

echo("Checking for Ora_error<BR>\n");

> $ora_error=Ora_ErrorCode($cur);

echo("Looking up error message.<BR>\n");

> $error=Ora_Error($cur);
> Ora_Close($cur);
> Ora_Logoff($conn_id);

So, you should at least be able to narrow it down.

Also, if the sql is broken up into several lines in your source... Don't do that. Some dbs can handle it. Some can't. 

-- 
--
-- "TANSTAAFL" Rich lynch <email protected>

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3