Home » Developer & Programmer » Reports & Discoverer » Reports 11g Compilation Error (oracle report 11gR2(,Windows server 2003 sp2)
Reports 11g Compilation Error [message #593973] Thu, 22 August 2013 05:50 Go to next message
Messages: 1
Registered: August 2013
Location: PUNE
Junior Member


i am doing report migration from 10g report to 11g version 11gR2( It is not converting into REP when I check the logs
I got compilation error, then I convert 10g RDF to 11g RDF and try to compile it in 11g report builder developer tool, It is giving me compilation error.

I am attaching the screenshot of the error please check it.

It is not allowing me any sql in that proc but if i comment it it get successfully compiled and if the same report i open with
oracle report 10g it get successfully compile.

Command using for Conversion:
rwconverter userid=<schema_name>/<schema_name>@tns batch=yes source=<source RDF path> stype=rdffile DTYPE=REPFILE dest =<Dest RDF/REP Path> OVERWRITE=yes

Somebody please help me to solve this i am not getting it.
Re: Reports 11g Compilation Error [message #594031 is a reply to message #593973] Thu, 22 August 2013 14:22 Go to previous message
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know why you got the error; however, SELECT FROM DUAL is something you can easily avoid, just rewrite
select to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') into :p_today_date from dual;
:p_today_date := to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss');
See whether it compiles, then.
Previous Topic: How to Disable print option in report runtime
Next Topic: ORA-02248
Goto Forum:

Current Time: Thu Dec 02 03:23:30 CST 2021