cancel
Showing results for 
Search instead for 
Did you mean: 

Viewing the SQL within the standard HANA procedures

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Wenjun,

Thanks. That answers my curiosity.
Wonder if there is any way we can trace what were executed when calling the procedure.

I tried activating the HANA SQL trace, but not helping .

Regards,
Henry

Former Member
0 Kudos

Hi Henry,

You're welcome. I don't think there is a way to see the details of built-in stored procedures.

Best regards,

Wenjun

Answers (0)