oracle insert won't work
| From: | Rudolf Frint | 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