Re: Database Function and Pro*C

"Yatin Patel" <yatin.patel_at_namerica.ikea.com> wrote in message news:8vc1bl$jlg$1_at_mailgate.ikea.com...
> Hi All
>
> I am writing one pro*c program, I have one database function e.g.
> myfunction, I want to call that database function from the pro*c program.
> Can I do that ? If I can then what is the syntax to call the database
> function.
>
> Thanks in Advance.
>
> YP

It's something like this (I might be a little off here though - haven't used Pro*C much myself):

EXEC SQL BEGIN DECLARE SECTION
  varchar my_var
END SQL DECLARE SECTION
 EXEC SQL SELECT my_function INTO :myvar;

-Matt Received on Tue Nov 21 2000 - 06:08:24 CET