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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
