| Oracle Discoverer Reports [message #174824] |
Tue, 30 May 2006 12:36  |
Amitgupta01
Messages: 2
Registered: May 2006
|
Junior Member |
|
|
Hi All,
For our project requirement, we need Discoverer report queries. As per our understanding, Discoverer keeps query dump into eul5_documents table doc_documents column in BLOB format.
1) My first question is that .....how can we retrieve SQL query report from EUL tables. Is there any way. (We tried TO_LOB function for changing doc_documents column into BLOB and then changing BLOB to CLOB. So we can read it. But it is not working. It is not coming in readable format. )
Our Aim is to find out SQL query of Discoverer report is readable format and we can store it in database in temp table so we can do our processing.
2) Second question, According to my understanding eul5_documents table has only one entry for workbook. So say if report has 5 sheet then for which sheet it is containing SQL query in doc_documents column or it is appending SQL's from diffrent workssheets in the same column.
3) Can we get query which Discoverer is using to show us SQL, when we try to get SQL using View -> SQL inspector.
please help us in this regard.
Thanks,
Amit
|
|
|
|
| Re: Oracle Discoverer Reports [message #175183 is a reply to message #174824] |
Thu, 01 June 2006 03:44  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Amit,
You are right in your last point, that you can see the sql generated by using the SQL inspector in Discoverer End User Edition.
For the first two points, I wonder what you are trying to accomplish. Could you explain what it is?
Regards,
Sabine
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
