Skip to Content
1
Jun 12, 2020 at 09:19 AM

Assign output of standard stored procedure in SQL HANA

255 Views Last edit Jun 12, 2020 at 09:21 AM 2 rev

Hi Friends,

I am using this standard procedure to get the structure definition of any table:

call get_object_definition ('SAP_ECC', 'TABLE1');

when we run this call statement by giving Schema and table name for which we want to grab the structure definition of the specified table as shown below:

I want to use the highlighted portion of the output in my own built stored procedure, so that I can use the structure definition and create queries based on that. However, there is no output parameter in this stored procedure. Hence, I cannot directly assign it to any table variable in stored procedure.

Can you guys please help me on how to assign an output column or the entire output table of a standard stored procedure in my own local stored procedure?

Thanks,

Gaurav

Attachments

stdproc.png (13.8 kB)