Re: HELP insert still dosn't work

On Tue, 20 Mar 2001 03:32, Rudolf Frint wrote: > > 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 the insert query 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 > > plaese help is very urgent > rudi I'm not an Oracle person, but it sounds like you may have a syntax error in your SQL. Try echo-ing $query and see how it looks. -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA