Re: Oracle functions and where clauses

Well, remove the OLEDB provider from the equation: Try it in SQL plus first. How you are calling the function presently makes no sense because Oracle cannot make a call to the OLEDB on your client machine (which is what it would have to do in order to evaluate the function call presented in OLEDB syntax)

"José Ramón Rodríguez" <jrrodriguez_at_multicorpora.ca> wrote in message news:kzoda.14592$8q2.181056_at_weber.videotron.net...
> Thanks for answering,
>
> I am doing it like that because it seems I am forced to use that syntax.
> That's the syntax the OLEDB provider for Oracle documentation uses all the
> time to call functions. I have tried it before with the syntax you suggest
> (which makes a lot more sense to me) and it gives an error too, it does
 not
> seem to recognize that syntax well.
>
> José.
>
> "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message
> news:CTOdnUhR5vhDneujXTWcjA_at_giganews.com...
> > Why are you doing this? Try this:
> >
> > select * from MC.SEC.QryTermbases(?, ?) where ID = ?
> >
> >
> >
>
>
Received on Mon Mar 17 2003 - 19:40:16 CET