Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to return RESULTSET from Oracle Stored Procedure?

How to return RESULTSET from Oracle Stored Procedure?

From: Vladimir Agajanov <vga_at_nyc-ot.com>
Date: 1997/11/12
Message-ID: <01bcef86$e689d4e0$b4320a0a@vgawks001>#1/1 







Hello,everybody!



I really do not know where to look for the answer that I have about Oracle.



THe question is: Why it is not possible to execute  SELECT * FROM TABLE
inside the body of Sored procedure?


From Sybase I know that stored procedure accepts IN, OUT, IN OUT parameters
but it also has a resultset. Then how can I achieve the same resultset on
the client side from Oracle stored procedure?



Any suggestions will be greately appreciated!



Vladimir 
Received on Wed Nov 12 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US