php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #2456 invalid character
Submitted: 1999-10-06 16:12 UTC Modified: 2006-07-17 08:42 UTC
From: herbert at widesoft dot com dot br Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 3.0.12 OS: Solaris
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [1999-10-06 16:12 UTC] 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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-10-07 02:25 UTC] thies at cvs dot php dot net 
there should be no semicolon at the end of the query!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Apr 27 08:01:29 2024 UTC