Oracle connection problem

Anon

Hi all,

I'm trying to use PHP with Oracle and I am having some problems with the ociexecute statement. I got the following error. What does it mean?

Warning: OCIStmtExecute: ORA-00936: missing expression in /usr/local/apache/htdocs/register/registration.php on line 33

My code is
$conn = ($user, $password, $db);
$sql = "Insert into users (name, age, title) values ($name, $age, $title)";
$stmt = ociparse ($conn, $sql);
ociexecute($stmt, OCI_DEFAULT);

The error is with the ociexecute line. Please help!

Anon

What is the Oracle explenation of error ORA-00936?

Anon

I have not idea what the error means. Would be grateful for help. Thanks

Anon

Well, find out what the error means and maybe that will help find out what is wrong.

Anon

I guess the variable value is not being sent across to the SQL statement. Have you tried doing a data dump of the values you've sent in to the SQL statement first? This Oracle error means that there's a problem with either the SQL statement or the datatypes of values passed to it. Have a nice time!

vucko

Here is your error code:

ORA-00936 missing expression

Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

Action: Check the statement syntax and specify the missing component.