Forum Stats

  • 3,782,440 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

Interactive Report - ORA-00600

Martin1
Martin1 Member Posts: 546 Bronze Badge
edited Oct 16, 2008 2:21AM in APEX Discussions
Hi,

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 Target
Link Icon: <img src="#IMAGE_PREFIX#e2.gif">
Target: Page in this Application
Page: 20
Name: P20_ID
Value: #ID#

APEX Version: 3.1.0.00.32
DB Version: 10.1.0.2.0

Without using the Link Column to a page it works fine.

I have in the same application already a page with a interactive report region and also i'm using there the Link Column to a page in the application.
Has soembody an idea what's the problem?

Thanks in advance.

Regards,
Martin

Edited by: Martin1 on Oct 14, 2008 11:03 PM
Tagged:

Answers

  • 20378
    20378 Member Posts: 577
    Hi,
    if you look into the alert.log file you may find more more information on why you get this error.

    Andy
  • M Tajuddin
    M Tajuddin Member Posts: 505 Bronze Badge
    Hi Martin,
    In interactive report, it normally uses the same page to display the record details when you click on the item link. Say if you have interactive report in page 20 and it would display the item details in page 20 when item link clicked. Is it the same page for displaying details? If not make sure you have referenced to the primary key column.

    I would prefer delete the report and create a new one, most of the time that make the job easier.

    Thanks,

    Tajuddin
    http://tajuddin.whitepagesbd.com
  • Martin1
    Martin1 Member Posts: 546 Bronze Badge
    Hi Andy,



    in the alert.log i can only see a pointer to a trace file in the udump directory. The trace file itself i'm not able to interpret :-(



    Thanks and best regards,

    Martin
  • Martin1
    Martin1 Member Posts: 546 Bronze Badge
    Hi Tajuddin,

    i link from the interactive report to another page in the application with reference to the primary key as i did in the first interactive report in this application.
    Yes i deleted the report and recreated it - two times - and the same problem.

    Thanks and regards,
    Martin
  • Martin1
    Martin1 Member Posts: 546 Bronze Badge
    edited Oct 16, 2008 2:21AM
    Hi,

    i found the problem :-)

    I did the following steps:
    1. Deleted and recreated the interactive reports region (with 'Link to Single Row View').
    2. Ran the report as developer, modified the settings (only the Sort).
    3. Saved the Report from the Actions Menu (As Default Report Settings).
    4. Changed the property 'Link Column' to 'Link to Custom Target' and the property 'Target' to 'Page in this Application'.
    That's all ...

    I think there is a little bug ;-)

    BTW the Upgrade to APEX 3.1.2 didn't help.

    Best regards,
    Martin

    Edited by: Martin1 on Oct 16, 2008 8:20 AM
This discussion has been closed.