Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Reports
try using Lexical References not Binf References
SELECT TEST_NUM from TABLE &where_clause then define the where_clause in user parameter "where TEST_NUM in(....)"
Good luck!
> -----Original Message-----
> From: Peter Hazelton [SMTP:peterhazelton_at_hotmail.com]
> Sent: Friday, August 18, 2000 9:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Reports
>
> This is how you would do it in SQL. I am in the query form of Oracle
> Reports. When you enter the string of numbers in, the bind variable is
> expecting one value and does not recognize the commas. Therein lies the
> trick somewhere and I am not sure where it is!
>
> Thanks for trying though, if you have any other info, please pass it on.
>
> Peter
>
>
> >From: "William Beilstein" <BeilstWH_at_obg.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Oracle Reports
> >Date: Thu, 17 Aug 2000 13:10:23 -0800
> >
> >replace your query with
> >
> >SELECT TEST_NUM
> >from TABLE
> >where TEST_NUM in (&P_TEST_NUM)
> >
> >This will be expanded at query time to include the bind variable
> >P_TEST_NUM. If you do this, you will have to make sure the user enters
> the
> >values in the following form
> >
> >10,11,12,13,40,50
> >
> >
> > >>> "Peter Hazelton" <peterhazelton_at_hotmail.com> 08/17/00 03:46PM >>>
> >I have a parameter set up on my report. Call it :P_TEST_NUM.
> >
> >My SQL query will be:
> >
> >SELECT TEST_NUM
> >from TABLE
> >where TEST_NUM = :P_TEST_NUM
> >
> >I want this parameter to accept several different numbers such as 1234,
> >1245, 1267 etc. I want this so that we don't have to run the report 20
> >times
> >for 20 different numbers, we just paste in a list of numbers and the
> report
> >runs for that list.
> >
> >Can this be done? If so, how and what is the syntax??
> >
> >Thanks
> >Peter
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: Peter Hazelton
> > INET: peterhazelton_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Author: William Beilstein
> > INET: BeilstWH_at_obg.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Peter Hazelton
> INET: peterhazelton_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Aug 18 2000 - 09:12:12 CDT