Re: bind variables and dynamic ref cursors
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 27 May 2008 10:39:48 +0300
Message-ID: <6e49b6d00805270039j25b3444ckc635c5c255f3a4fd@mail.gmail.com>
Date: Tue, 27 May 2008 10:39:48 +0300
Message-ID: <6e49b6d00805270039j25b3444ckc635c5c255f3a4fd@mail.gmail.com>
See this thread for discussion of various approaches:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1288401763279
Gints Plivna
http://www.gplivna.eu
2008/5/27, Rick Ricky <ricks12345_at_gmail.com>:
> I am writing stored procedures that return ref cursors to developers. For
> one query they have the option to send me 2 or 3 parameters. So this means I
> need 2 or 3 where clauses. using a dynamic ref cursor, how do i use 2 or 3
> bind variables since the number of where cols = statements will vary?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 27 2008 - 02:39:48 CDT