Hi,
I searched the forum for this, but didn’t get any proper result, maybe my keywords were not perfect.
Can anyone tell me how can I retrieve the sql of the reports from the repository tables. Is it feasible?
Regards,
Bis.
Biswajit Sarkar 
(BOB member since 2003-11-25)
Can anyone tell me how can I retrieve the sql of the reports from the repository tables. Is it feasible?
What do you mean by that? could you please clarify the issue a little bit.
Manasi (BOB member since 2004-12-17)
Take a look at this past topic.
The problem is that the SQL of the reports is not exactly stored in “repository tables”. If your document has been exported to the “repository”, it exists as a BLOB in OBJ_X_DOCUMENTS, and you would not easily be able to pull the SQL out of anything.
Anita Craig 
(BOB member since 2002-06-17)
Yep, thats what I thought any only the information regarding the document
properties is stored. not the actual sql
Manasi (BOB member since 2004-12-17)