Home » Developer & Programmer » Reports & Discoverer » Show SQL of a rep ...or a form
Show SQL of a rep ...or a form [message #136170] Tue, 06 September 2005 08:28 Go to next message
scorpion2l
Messages: 2
Registered: September 2005
Location: Iasi
Junior Member
Hi everybody...

I'm newbie in Oracle and I was wondering if it is posible to find out the SQL statements (or the Procedures // triggers called ) used by a Oracle Reports Executable (.rep) ?

The same question i have , but for Oracle forms. I have an application at work made in Oracle, and I saw once the IT specialist (send by the developer to debug some problems in the aplication ) showing a window with some SQL statements with some combination of keys, while the program was running. I belive these were the SQL statements used in that moment by the form ... and I was wondering what is that combination of keyboard to see it. And if it's work on reports running too.

If anyone could tell me I would be thanksfull.

PS. Sorry for my English.

Report message to a moderator

Tables / colums used by a .Rep [message #136172 is a reply to message #136170] Tue, 06 September 2005 08:38 Go to previous message
scorpion2l
Messages: 2
Registered: September 2005
Location: Iasi
Junior Member
And another question ... I would not create a new topic for it ... so I write it here:


How can I find the Oracle tables (colums of the table) used by a Oracle Reports executable (.rep) ?

I think it must be some PL/SQL script that could do that ...

Report message to a moderator

Previous Topic: Discoverer 4.1 - get first date of month using sysdate
Next Topic: REP-1804 report error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 23 14:40:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.