OraFAQ Forum: Reports & Discoverer » Reports 11g Compilation Error

Home » Developer & Programmer » Reports & Discoverer » Reports 11g Compilation Error (oracle report 11gR2(11.1.2.0.0),Windows server 2003 sp2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reports 11g Compilation Error [message #593973]

Thu, 22 August 2013 05:50

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.

Attachment: Report11g_err.jpg
(Size: 270.81KB, Downloaded 2060 times)

Report message to a moderator

Re: Reports 11g Compilation Error [message #594031 is a reply to message #593973]

Thu, 22 August 2013 14:22

Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic:	How to Disable print option in report runtime
Next Topic:	ORA-02248

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 09:47:30 CDT 2025