Unable to create a report based on a text field which returns , separat val

10-11  Source: Network gathering  Views:0 

Advertisement
hi,
i have created a sql report which fetches the values depending on values in text field,
select * from emp where empno in :P2_xwhere P2_x is a text field,
if i enter only one value then report is generated and if i enter two values separated by ","
says no data found
thanks,
Little Foot
>
i have created a sql report which fetches the values depending on values in text field,
select * from emp where empno in :P2_x
where P2_x is a text field,
if i enter only one value then report is generated and if i enter two values separated by ","
says no data found
>
In
select * from emp where empno in (7788, 7839, 7876)<tt>(7788, 7839, 7876)</tt> is an expression list and the predicate is evaluated as a membership condition.
In
select * from emp where empno in :P2_x<tt>:P2_X</tt> is a scalar string, incapable of containing multiple values.
See +varying elements in IN list+ on Ask Tom, and +emulating string-to-table functionality using sql+ for potential solutions.
In an APEX standard report, use a PL/SQL function body returning an SQL query report source with lexical substitution to produce a "varying IN-list":
return 'select * from emp where empno in (' || :P2_X || ')';where <tt>P2_X</tt> has been sanitized for SQL injection and string values are properly quoted.
Related articles
  • Unable to create a report based on a text field which returns , separat val 10-11

    hi, i have created a sql report which fetches the values depending on values in text field, select * from emp where empno in :P2_xwhere P2_x is a text field, if i enter only one value then report is generated and if i enter two values separated by ",

  • How to create a report based on a DataSet programatically 10-11

    I'm working on a CR 2008 Add-in. Usage of this add-in is: Let the user choose from a list of predefined datasets, and create a totally empty report with this dataset attached to is. So the user can create a report based on this dataset. I have a data

  • Unable to create a report in bi publisher 10g 10-11

    Hi All, Unable to create a report in bi publisher. When we tried to create a report abcd, then it is giving the below error. Operation failed: /abcd/abcd.xdo. When we tried to create a report with the existing name, it is saying An object with the sa

  • How to create a report  based on selected item from Select list? 10-11

    Hi, I have created a tables_LOV based on: select table_name d, table_name r from user_tab_cols where column_name like '%_type%' Then I created a page item ListOfTables,  Display as select list and pointing to tables_LOV. I run the page, and i can sel

  • Create a report based on sample data! 10-11

    Hello all, I would like to get some helps for creating a report based on the following table data in the database: Class     |        Name                   |         Student ======================================= 1            |        Algebra      

  • Creating a Report based on different schema objects 10-11

    Hi, I have a situation in creating Reports for my database performance. Let me explain my requirment. There are 2 schemas in my database called X, Y X owns all the performance related data. But Y has read access on X objects. Now in APEX I have a dev

  • Can I create a report based on Non-Oracle template? 10-11

    Hi: I have a Microsoft Word document that contains the entire layout of a report I need to create with Oracle Report 6i. I know that I can create a report based on a template, but as I understand it, I am limited to using Oracle Reports templates. Do

  • Hi Folks,   I have a problem with OBIEE EM, There in Enterprise Manager i am unable to navigate into the options like when i clik on any Tab it is not working and even  i am unable to create a report using analysis. 11-30

    Hi Folks,   I have a problem with OBIEE EM, There in Enterprise Manager i am unable to navigate into the options like when i clik on any Tab it is not working and even  i am unable to create a report using analysis. Thanks in advancei have also tried

  • Unable to create web reports using WAD in BI 7.0 11-30

    We are unable to create web reports using WAD in BI 7.0 because of the missing BI metadata. Please take a look at the error below .didnt see the error??Read other 2 answers

  • Need Report based on "CUSTOM DATA field @ Shop Order Maintenance" 11-30

    Need the REPORT based on CUSTOM DATA field. Requirement - I am having the CUSTOM data at Shop Order Maintenance that is called as XXX, I need some report in SAP ME which can display the SFC related to particular Shop order based on XXX Number.Hi! As

  • How to create a report based on the portal30.wwsbr_all_items? 10-11

    Hi, I created items in a folder in a content area. I would like to create a portal report and display the items of the folder of the content area. I logged in the database as portala30 and issued the following statement: SELECT ID,NAME FROM WWSBR_ALL

  • How to create a report based on the selection of a node of a tree 10-11

    Hello, I am new to Oracle Apex and I was trying to build a tree and also an interactive report based on the empno column of the emp table. I have created a tree based on emp table. Now I want to display records of the employee selected in the tree. H

  • How to create a report based on radia selection 10-11

    Hi, I am new bie to Appex, I have a requiment to generate a report based on existing table with the select creditaria. I mean, the select creditaria wil be the radio button, if i click any option the report will change accordingly. It is nothing but

  • Creating a report based on a calendar 10-11

    Hi there! I would appreciate if anyone helps me with this issue. I've to manage a report based on a calendar. It is based on a monthly calendar in which you can see data for each day, then you can drill down to a weekly view and even a daily one (the

  • Discoverer 4i:i have to create a report based on the two columns 10-11

    Hi, I have to create a report(workbook) that will have 2 parameters from date & to date.i have to apply a validation that from date should be lesser then to date.Do reply Thanks,The methods described by user564110 will work, but may not give the resu

  • Unable to create a report painter form (Message no. KH205). 10-11

    Dear all, I am trying to create a report painter form, but the system gives an error: Key figure scheme  contains errors -> check definition Message no. KH205 Diagnosis Entry   not contained in Table T237A. Procedure Check key figure scheme  (in part

  • Unable to create a subsite based on the generic template - save site as a template 10-11

    hi, am using a  save site as a template functionality to create a sub site. when i select the custom template, and click on ok button,am  getting server error in appln. in the site template i have 1) 2 document libraries with permissions broken[ stop

  • Unable to create webI report?? 10-11

    HI all I am using BO XI3.1 SP3, when I logged into infoview and click on the new webintelligence document, I see universes available and select the universe then it is showing as "PLUGIN's NOT INSTALLED" instead of showing the query panel of the

  • Create a report based on another 10-11

    Hi, i've following question. I have a report A composed by an union of two queries. Example: Select X,Y from Subject Area UNION Select W,Z from Subject Area Is possible create another report which select any fields of the report A? Example: Select Y,

  • Create a report based on subform 10-11

    Hi  I have a Main form which includes a Subform that contains all the information regarding a meeting at a specific date. I would like to create a button, to create a report for only this specific date. How can I let user to generate a report when th