result of stored function

I do requests throw a application which calls the oexec() function of OCI interface (oracle v7) and gets the result throw the ofetch() function.

this is my problem :
I need to do some complex queries and i'd like to store these queries in stored functions or procedures.
i need to get the result like a SELECT statement because i must use the predefine application calls.

ie, i can do :

EXEC($cursor, "SELECT ...."); /* calls oparse, oexec */
$result = FETCH($cursor); /* calls ofetch */

i can do also :

EXEC($cursor, "BEGIN foo(bar); END;");

but i'd like to do :

EXEC($cursor, ".... foo(bar);...");
$result = FETCH($cursor);

  with foo(bar) which returns a query result.

How can i do that ?

Regards,

    bruno Received on Fri Jul 17 1998 - 08:53:08 CDT