Skip to Content
avatar image
Former Member

SQL Script: Passing variable by reference, not by value

Hello Experts,

Does SAP HANA 2.0 support passing variable by reference, between procedures/functions, in order to reduce the memory usage per session?

Is passing variable by reference, default in Hana?

Please note that I am not referring to IN/OUT/INOUT directions.

We are currently dealing is fairly large CLOB values and would like to keep the memory footprint low per session, while performing these operations. Passing by value, would be expensive, in terms of memory.

I have browsed through the SQL Script reference and found nothing.

Essentially, I am looking for an Hana equivalent for Oracle's NOCOPY tag.

Thanks & Regards,

Satish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers