oracle insert won't work

From: Date: Mon, 19 Mar 2001 08:43:20 +0000
Subject: oracle insert won't work
Groups: php.general 
Request: Send a blank email to php-general+get-44503@lists.php.net to get a copy of this message
I'm getting $FF from another PHP-Page and then I want to insert the Values into my Database like this $handle = ora_logon("iusr@test","kiwi1"); $cursor1 = ora_open($handle); $query = "insert into internet_tmp select rv_ret($FF),$FF,$sesid,(sysdate+0.0021) from dual"; ora_parse($cursor1,$query) or die; ora_exec($cursor1); ora_close($cursor1); tring this on sql-plus works fine what do I do wrong?? oh yea error msg is like this Warning: Ora_Parse failed (ORA-00923: FROM keyword not found where expected -- while processing OCI function OPARSE) in test2.php on line 40 line40 is parse line

« previous php.general (#44503) next »