How to get HANA stored procedure definition text using ODBC and JDBC?

[Former Member]

Hello,

    I want to know how to get the definition of a HANA stored procedure using ODBC and JDBC API.

Thanks in advance.

[Former Member · Accepted solution]

select definition from sys.procedures where schema_name='schema_name' and procedure_name='MYPROC'

[former_member182302]

Hi Sen,

Well I was not able to get hold of any API. But got a query which can give the same information using prepared statement.

SELECT DEFINITION FROM SYS.PROCEDURES 
WHERE SCHEMA_NAME = 'SCHEMANAME' and PROCEDURE_NAME = 'PROCEDURENAME'

Regards,

Krishna Tangudu