Select * from ... in procedure


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Select * from ... in procedure

  1. #1
    Richard MARCHAND Guest

    Select * from ... in procedure

    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.


    Share on Google+

  2. #2
    mister pants Guest

    Re: Select * from ... in procedure


    "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
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center