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

Hi,

i am doing report migration from 10g report to 11g version 11gR2(11.1.2.0.0). 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
Littlefoot
Messages: 21805
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;
to
: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: Mon Mar 18 22:02:47 CDT 2024