Select * from ... in procedure

[Richard MARCHAND]

Hi,

I would create a procedure or a function that return the result
of a "select * from employe" in Oracle.

How can I do, because after I would open this procedure
with the ado component (Microsoft)

Please help me,
In advance thank you.

[mister pants]

"Richard MARCHAND" <r.marchand@specinov.fr> wrote:
>Hi,
>
>I would create a procedure or a function that return the result
>of a "select * from employe" in Oracle.
>
>How can I do, because after I would open this procedure
>with the ado component (Microsoft)
>
>Please help me,
>In advance thank you.
>
>


Bummer, you're out of luck there, me old mucker, you can't do that in Oracle
SP's.

You need to look up the documentation on using REF CURSORS.

Look at http://technet.oracle.com