Re: jump 2 next iteration of FOR loop
From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 8 Apr 2004 07:30:32 -0700
Message-ID: <3722db.0404080630.608939a4_at_posting.google.com>
Date: 8 Apr 2004 07:30:32 -0700
Message-ID: <3722db.0404080630.608939a4_at_posting.google.com>
> i wanna pass a table as a parameter to a function
> how do i go abt doin' this??
> CREATE OR REPLACE FUNCTION blah(tblname IN ........)
> plzz help
> Thnx!!
Define the parameter as a REF CURSOR, and invoke the function with the parameter CURSOR(select * from tblname).
HTH Daniel Received on Thu Apr 08 2004 - 16:30:32 CEST