| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Reports
Your Bind variable must be of type character for this to work. If it is a =
number, the syntax will not be accepted.
>>> "Peter Hazelton" <peterhazelton_at_hotmail.com> 08/18/00 09:04AM >>>
This is how you would do it in SQL. I am in the query form of Oracle=20
Reports. When you enter the string of numbers in, the bind variable is=20
expecting one value and does not recognize the commas. Therein lies the=20
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=20
>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=20
>P_TEST_NUM. If you do this, you will have to make sure the user enters =
the=20
>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 =3D :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=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=
=20
>
>--
>Author: Peter Hazelton
> INET: peterhazelton_at_hotmail.com=20
>
>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=20
>
>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).
--=20
Author: Peter Hazelton
INET: peterhazelton_at_hotmail.com=20
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:13:40 CDT
 |
 |