on 09-03-2014 3:31 PM
Hi all,
I would like to see the SQL to be executed when I call for the procedure e.g. CHECK_TABLE_CONSISTENCY
Is that possible?
I tried to click on Catalog > SYS > Procedures > Right click on the procedure & "Open Definition"
I can see there's a "create procedure" statement, but do not see the statement that would be executed by this procedure.
Please advise.
Thanks,
Henry
Hi Henry,
As far as I know, the content of most built-in stored procedures are not visible. When you open the definition, you can just see something like "CREATE PROCEDURE XXX (XXX, XXX, ...) AS BUILT IN".
Best regards,
Wenjun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.