invalid charachter error: Warning: OCI

[Anon]

I cannot get this command to insert data into my table:

<?
include("connect.inc");

$Insert = "insert into ticket(tk_id, tech_id,priority,status,calls,o_num,t_num, sw, dte_o, dte_a,dte_c,req,issues,tg_o,tg_t,calltype,sw_type,ssw) values (tk_seq.nextval,'$tech_id','$priority','open','$number','$onpa$onxx$oline','$tnpa$tnxx$tline','$sw','','','','$req','issue','4444','4444','$ct','$sw_type','ssw' ) ; ";

$Statement = ociparse($Connection,$Insert);

ociexecute($Statement);

print $Connection;
print $Insert;
?>

I can insert it into the database itself and it will take!
Any suggestions?

[reagent]

Why aren't you using OCIBindByName() ? I expect that error comes from a single quote(') in one of your variables. OCIBindByName() will escape that for you.

http://www.php.net/manual/en/function.ocibindbyname.php

hth