jump 2 next iteration of FOR loop

[DottingTheNet]

Hi!

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!!

[Daniel Roy]

Re: jump 2 next iteration of FOR loop

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