thx very much
oracle statments don't need " but ' and it did exaktly what it should
At 01:30 20.03.2001 +0100, you wrote:
>On Tue, 20 Mar 2001, David Robley wrote:
>
> > 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
> >
>
>I've had a few troubles with PHP/MySQL with requests like that... Maybe
>you could try that (it worked for me) :
>
>$query = "insert into internet_tmp select
>rv_ret(\"$FF\"),\"$FF\",$sesid,(sysdate+0.0021) from dual";
>
>the \"$var\" are important : ".$var." won't do, even if with an echo
>$query, you _seem_ to get the same results...
>
>--
>Ben
>As well look for a needle in a bottle of hay.
> Miguel de Cervantes
>
>
>--
>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]
