Re: Database Function and Pro*C

In article <8vc1bl$jlg$1_at_mailgate.ikea.com>,   "Yatin Patel" <yatin.patel_at_namerica.ikea.com> wrote:
> 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
>
>

The manual documents the use of embedded PL/SQL and calling SQL statements. Both work. The later you use something like

           select myFunction(<arguements>) into <variables> from dual

using PL/SQL, one writes an anonymous PL/SQL block with the function and variables within it.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 20 2000 - 23:11:35 CET