Advanced Search

Return to Snippet

Revision: 651
at July 25, 2006 17:38 by rengber
Initial Code 
CREATE OR REPLACE PROCEDURE RobCursorTestProc
(
  my_cursor IN OUT SYS_REFCURSOR
)
AS
BEGIN
  OPEN my_cursor FOR
    SELECT  TABLE_NAME,
            OWNER				
    FROM ALL_TABLES;
END;
SHOW ERRORS;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Oracle Stored Proc to Return a Recordset (Oracle Side)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL