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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

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-2020 The PHP Group
All rights reserved.
Last updated: Sat Jan 18 14:01:23 2020 UTC