Home -> Usenet -> comp.databases.oracle -> Oracle Noob need help with function

Oracle Noob need help with function

From: spawncamper <jerel_at_rockbaby.com>
Date: 27 Jul 2004 12:57:32 -0700
Message-ID: <f2f4fe50.0407271157.189f42ff_at_posting.google.com> 





Hi -



I posted here a few weeks back and people were kind enough to help. 
In lieu of my PL/SQL class I take in a few weeks, I was hoping to get
some more advice.



Here's my scenario:  I need a function to return a table of data for
Oracle8i.


I'm fairly certain of the stucture for the function, but am hazy on
the details.



CREATE OR REPLACE FUNCTION test_function (id in varchar2)



          return table ****i know this isn't correct



IS


          TYPE    	ref0 IS REF CURSOR;
	  cur0        	ref0;





BEGIN



          OPEN cur0 FOR 
  	 	select id, name from user where id = id;
	
     *****PERFORM SOME SORT OF LOOP AND ASSIGN TO VARIABLES - AM HAZY


HERE****

         
         return table;


end;



Any assistance is greatly appreciated.  Thank you for your time.
Received on Tue Jul 27 2004 - 21:57:32 CEST












Original text of this message