OraFAQ Forum: Reports & Discoverer » Unable to parse query

Home » Developer & Programmer » Reports & Discoverer » Unable to parse query (reports developer 2000)

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

Unable to parse query [message #395425]

Wed, 01 April 2009 07:24

privs
Messages: 11
Registered: February 2009
Location: South Africa

Junior Member

Can anyone help me, i wrote a report code and it works in version 6i but when i put that query in ver 4.5 it gives a REP-0496: Internal Error - Unable to parse the query

Can anyone help me

I nclude the query for your perusal

Attachment: Report query.txt
(Size: 2.14KB, Downloaded 1189 times)

Report message to a moderator

Re: Unable to parse query [message #395428 is a reply to message #395425]

Wed, 01 April 2009 07:39

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

I imagine version 4.5 doesn't recognize ANSI SQL.

Report message to a moderator

Re: Unable to parse query [message #395430 is a reply to message #395428]

Wed, 01 April 2009 07:43

privs
Messages: 11
Registered: February 2009
Location: South Africa

Junior Member

is there any way i can overcome this problem?

Report message to a moderator

Re: Unable to parse query [message #395449 is a reply to message #395425]

Wed, 01 April 2009 08:26

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Don't use version 4.5 - it's been desupported for years.

Otherwise you're going to have to rewrite your sql to non-ansi syntax.

Report message to a moderator

Re: Unable to parse query [message #395451 is a reply to message #395449]

Wed, 01 April 2009 08:31

privs
Messages: 11
Registered: February 2009
Location: South Africa

Junior Member

but i have to do it in 4.5 also so sad for me Sad

Report message to a moderator

Re: Unable to parse query [message #395500 is a reply to message #395451]

Wed, 01 April 2009 12:06

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So use 4.5 version - just rewrite the query!

In other words (and as an example), instead of

SELECT e.ename, d.dname
FROM EMP e left join DEPT d
ON e.deptno = d.deptno

you'd have

SELECT e.ename, d.dname
FROM EMP e, DEPT d
WHERE e.deptno = d.deptno

[Updated on: Wed, 01 April 2009 12:09]

Report message to a moderator

Re: Unable to parse query [message #395611 is a reply to message #395500]

Thu, 02 April 2009 01:14

privs
Messages: 11
Registered: February 2009
Location: South Africa

Junior Member

Thanks, I'll try to uncomplicate my query (bearing in mind I'm still new at SQL Smile

)

Report message to a moderator

Re: Unable to parse query [message #395688 is a reply to message #395425]

Thu, 02 April 2009 04:48

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Another trick you can try is create a view based on your query then query that in the report.
reports 4.5 might not know ANSI sql but it should know views (I'm guessing - never used that version).

Report message to a moderator

Re: Unable to parse query [message #395692 is a reply to message #395688]

Thu, 02 April 2009 05:02

privs
Messages: 11
Registered: February 2009
Location: South Africa

Junior Member

I will try that. thanks . If that wot work, I may just split it into8 separate queries then use it that way in the report as 8 different groups

Thanks

Report message to a moderator

Previous Topic:	Error While Generating Report REP-00999 Unimplemented Error
Next Topic:	Error while exporting Data from discoverer viewer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 16 07:12:04 CDT 2024