php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: herbert at widesoft dot com dot br
New email:
PHP Version: OS:

 

 [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

Pull Requests

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: Thu Dec 26 21:01:28 2024 UTC