Skip to Content

HANA Stored procedure output to a table

Feb 27 at 01:32 PM


avatar image

Hi All,

I am calling call get_object_definition procedure inside my own stored procedure

call get_object_definition ('SAP', 'SAMPLE');

and i want to store the output (object creation statement column value) in a temporary table of my main procedure , Is that possible?? and can some one help on this ?? Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Feb 28 at 12:58 AM

This procedure returns an implicit result set and those cannot be bound to a table variable or otherwise referenced in SQL/SQLScript.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Thanks Lars , one more question any idea from which system table/view this procedure get_object_definition is using to fetch the data ?? so that i can directly use that table myself ??


Dilip Deenadayalan

I'm sure that this question has been asked and answered before here in the HANA community.

I leave it to your mad google skills to dig up that old discussion (or the product documentation).


Thanks Lars , let me try my luck , thanks