Home » Developer & Programmer » Reports & Discoverer » Unable to view the SQL code for work sheet in discoverer report
Unable to view the SQL code for work sheet in discoverer report [message #213236] Tue, 09 January 2007 23:16 Go to next message
sreedevi_83
Messages: 43
Registered: October 2005
Location: India
Member
Hi All,
I get blank when I try to see the sql query for work sheet of a particular discoverer report using View->Sql Inspector.
But when I login to same reponsibility and try to view sql code for another report, I am able to see the query.

Any suggestions to trace out why it is happening?

Thanks in Advance,
Sreedevi.

Report message to a moderator

Re: Unable to view the SQL code for work sheet in discoverer report [message #213344 is a reply to message #213236] Wed, 10 January 2007 06:54 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Hi Sreedevi,

Did you let the worksheet run for a little while? If you go to the SQL inspector too soon, it will not have generated the code yet.

Regards,
Sabine

Report message to a moderator

Re: Unable to view the SQL code for work sheet in discoverer report [message #213470 is a reply to message #213344] Wed, 10 January 2007 22:18 Go to previous messageGo to next message
sreedevi_83
Messages: 43
Registered: October 2005
Location: India
Member
Hi Sabine,
Thanks for your reply. I have checked for sql query after getting the output.
The report was shared to me by the owner of report. I now came to know that the owner of the report is able to see the sql query using sql inspector.
I think I am unable to see the query because I am not the owner of it.
Thanks,
Sreedevi.

Report message to a moderator

Re: Unable to view the SQL code for work sheet in discoverer report [message #213992 is a reply to message #213470] Sat, 13 January 2007 07:13 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Tried to reproduce this using Discoverer desktop version 10.1.2.1. But sharing doesn't have any effect, I can still see the sql generated.
What version are you working with?

Report message to a moderator

Previous Topic: ORA 01476 error in discoverer
Next Topic: Upgradation of Oracle Discoverer from release 4 to 9i.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 00:26:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.