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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: jump 2 next iteration of FOR loop

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@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 - 09:30:32 CDT

Original text of this message

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