Oracle Interactive report: ORA-01788

I have created an Interactive Report based on a simple SQL (SELECT * FROM A_TABLE_NAME). When, the page is rendered I am getting this error : 'ORA-01788: CONNECT BY clause required in this query block'. Why am I receiving an error like that? How it can be solved?

Oracle Interactive Report - ORA-06502 String Buffer Error

Currently using APEX 3.1.1 and when trying to execute an Interactive Report (with 150+columns) and I am getting the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small. Is there a way to increase the string buffer or a way to solve this problem? ...

Oracle Interactive Report - ORA-00600

i made an interactive report. When i use the 'Link Column' with the following properties i get an error:'ORA-00600: internal error code, arguments: [12410], [], [], [], [], [], [], []'Here the properties:Link Column: Link to Custom TargetLink Icon: <img src="#IMAGE_PREFIX#e2.gif">Target: Page ...

Oracle Interactive Report and ORA-01741: illegal zero-length identifier

When trying to run the interactive report I am receiving ORA-01741 : illegal zero-length identififer After reading a previous thread (which is similar, but it is not related to interactive reports) I have tried...1. wrapping the report source columns with NVL - no success2. wrapping the view columns ...

Oracle Interactive Report charts...multiple series?

I've been evaluating APEX 3.1 and especially the interactive reports feature. I mostly like what I see, but to be useful to me there are a couple of pieces of functionality that I don't see. Maybe they are there and I'm not looking in the right place. Here are things I would like to see if possible: ...

Oracle interactive report conversion

I am having two report regions on my page. The application was built on Apex 3.0 and imported into 3.1I am finding the option to convert the report in the 1st region to interactive report.However for the report in the 2nd region, the option is not available.Is this a limitation? ...

Oracle Interactive Report Functionality At 3.0

Just looking at the the new Interactive Report Functionality and its exactly what the users here are after.The problem is we are stuck at 3.0 and I cant get the upgrade for a while so i was wondering if any had created similar functionality at 3.0 and would be willing to share it. ...

Oracle Interactive report feature request

HiIt would appear developers have lost a quick way of selecting to sum columns with interactive reports.I have migrated many reports which have over 30 columns that had SUM totalling on them.Problem is they didn't migrate the SUM totalling and I have to manually add them back via the Interactive rep ...

Oracle interactive report: value of item in link column bug

I have a field in my table called APP_IDI am trying to assign a value to one of the items called P7_APP_IDD in the link column of the interactive report.As far as I know i user #APP_ID# to refer to the field in the table .. BUT the value is always changed to &APP_ID. automatically displaying the ...

Oracle Interactive report errors when trying to query external table.

I'm trying to create an interactive report against an external table and getting the following error. I see a note in metalink the describes its cause, but I doesn't seem to apply here.Query cannot be parsed, please check the syntax of your query. (ORA-06550: line 2, column 17: PLS-00302: component ...

Oracle Interactive report forms in polish language

I plan to use forms with interactive report. This report have standard help page. How can I translate it for polish users?Best ...

Oracle Interactive Report - Saving for Developers Only?

I am looking at the Interactive Reports. When you make some changes and hit the save option, it has 'Only displayed for Devleopers' next to the 'Save' drop down. What does this mean? Can only users who are developers save reports? Please explain ...

Oracle Interactive Report with PDF BLOB

I have a table with a blob that contains a PDF, is there a way that I can convert this to an IRR? I don't want to view the PDF contents I just want to search that blob field it using my oracle text index (and obtain the scoring) and my other fields normally....Here is my original query syntax:SELECT ...

Oracle interactive report bug - html at end of report

I've noticed that in all of my interactive reports, when I save to CSV, the resulting file contains the extraneous lines of html at the bottom:</td></tr></table>I'm curious - has anyone else noticed this, and if so, do you know of a workaround? ...

Oracle Interactive Report PDF Footer

We are replacing a bunch of Crystal reports with the new interactive reports. When we download an interactive report to PDF, it automatically puts the page number at the bottom right of every page. However, I'd like it to say "Page 1 of 3", "Page 2 of 3", etc. on the right side of the footer. And I' ...

Oracle Interactive report - highlight selected row

I'm very new at this and this might be a stupid question, but I can't do it so.. I have an interactive report, with a column that is a link and it passes the id to detail tables. So when I click on the link, I get the details for that row.How can I highlight the row with the link I just clicked on? ...

Oracle Interactive Report Region losing highlight during export

Anyone else got this issue/know a solution?If I have an Interactive Report Region (IRR) and I add some conditional row highlighting it works perfectly!Now I want to save my 'sexy' report to Excel/PDF (Yes I have got APEX talking happily to BI Publisher). My problem is that, whilst the report gets ex ...

Oracle Interactive Report - Compute problem

When I try and to anything with the "Compute" option of an interactive report I get:Invalid computation expression. ORA-00942: table or view does not existAnyone know why? or which table may be missing? ...

Oracle interactive report charset problem

I have created an interactive report.But I have a problem in search field like this:in my table there is turkish characters and when I tried o search a row in my table from the search field no rows returned how can I solve this charset problem in search area. ...

Oracle Interactive Report. Cell highlight.

I'm using highlight functionality in Interactive Report actively and appreciate for this feature. Question: is it possible to define ONE highlight rule to ALL cells in every column. for example I need that any cell in the report which contains number 5 must be highlighted as Red ?I make a simple cal ...

Oracle Interactive Report with 2 tables

I want to create an Interactive Report (and Form) based on 2 tables which are joined together with FK_MODULE from FORM table 2 PK_ID from MODULE table.Do I just edit the SQL that got created from the wizard (which only asked for 1 table) to display the appropriate description (instead of primary key ...

Oracle Interactive Report with multiple SQL

I have an Interactive report that currently show info from 1 query. I want to be able to include info from another query on the report (like a master detail).I see it mentioned on the New features that it can now support multiple SQL's. How do you do it? ...

Oracle Interactive report multi-word search

HelloCan the Interactive Report do a multi-word search?I'm just trying to search the words 'hello' and 'world' in the string 'hello to you, world'. Is that possible with a single hit of Go? ...Maybe a special character that separates the words?! ...

Oracle Interactive Report -- no data show by default

I need when navigate to the page with Interactive Report, by default no data would show until user make select criteria.How can I do it? ...

Oracle Interactive Report. Mandatory column

Is it possible to define some columns as mandatory to show in Interactive report? I mean when we give to user a right to hide some columns it is possible to hide all columns as well. It would be usefull to have an ability to define some columns as mandatory disabling abitity to hide such a column fo ...

Oracle interactive report - strip HTML

Where is the option to strip HTML for an Interactive report? Is it possible to set this option for each column?N.B. This setting can be found under Layout and Pagination for classic report. Thanks,Louis-Guillaume Homepage: http://www.insum.caBlog: http://insum-apex.blogspot.com ...

Oracle Interactive Report with static lov

i have a classic report with images view of status valuefor example Status 'Open' --> Red Ball imageStatus 'Close' --> Green Ball imagesHow to do this in an interactive report? ...

Oracle Interactive report cell highlighting and computation

I have started using the interactive reports and must say tat its just amazing. Everyone here loves them. But I am facing 2 problems.1) I cant use relational operator in computation provided alongwith the report. For eg a simple case stmt CASE WHEN T > 0 THEN S * 100 / T ELSE 0 END doesnt wrk. Er ...

Oracle Interactive Report variable

I would like to use a TextField page item (p1_my_item) in an interactive report.e.g.select <p1_my_item>from dual- Problem is I don't want to have to submit the page in order to access the value of p1_my_item (e.g. it is not in the session). - I would like the user to be able to enter text into ...

Oracle Interactive report problem

I like most of the features in the interactive report, but I also found some not good stuffs along with it.1. performance , sometimes we want to search something in the search box, but it just , the small dot circle circling and nothing is happened, we have to refresh the page and try again.2. befor ...