Skip to Content
0

SQL Script: Passing variable by reference, not by value

Apr 17, 2017 at 04:29 AM

47

avatar image

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

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

0 Answers