#2456 [Csd->Bgs]: invalid character
| From: | tony2001@php.net | Date: | Mon, 17 Jul 2006 08:42:55 +0000 |
| Subject: | #2456 [Csd->Bgs]: invalid character | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-99516@lists.php.net to get a copy of this message | ||
ID: 2456
Updated by: tony2001@php.net
Reported By: herbert at widesoft dot com dot br
-Status: Closed
+Status: Bogus
-Bug Type: Oracle related
+Bug Type: OCI8 related
Operating System: Solaris
PHP Version: 3.0.12
Previous Comments:
------------------------------------------------------------------------
[1999-10-07 02:25:48] thies at cvs dot php dot net
there should be no semicolon at the end of the query!
------------------------------------------------------------------------
[1999-10-06 16:12:45] herbert at widesoft dot com dot br
the script is
$ps = 'insert into tideia ';
$ps .= '(snome, semail, sassunto, mmideia, sip) values ';
$ps .= "('$nome', '$email', '$assunto', '$ideia',
'$ip');";
$c = ocilogon("login", "password", "ORACLEID");
$s = ociparse($c, $ps);
ociexecute($s, OCI_DEFAULT);
ocilogoff($c);
the result is
Warning: OCIStmtExecute: ORA-00911: invalid character in
/usr/local/system/wideadm/www/eparpite/adicdb.php3 on line 31
OCIDebug: _oci8_free_stmt: id=2 last_query="insert into tideia (snome,
semail, sassunto, mmideia, sip) values ('Herbert G. Fischer',
'herbert@widesoft.com.br', 'Site de Downloads', 'hello world',
'127.0.0.1');"
I've tryed anything but it always give me this error.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=2456&edit=1