HANA and L-lang

[Former Member]

Hello

I am trying to call a stored procedure in L-lang from an SQL-Script procedure.

Can you give me an example how can i use L in stored procedures?

Thanks

[schneidertho]

Hi Tamas,

to my knowledge L is currently not release for usage by customers / partners.

Best regards

Thorsten

[Former Member]

Hi,

Is it possible to create the L language based procedure? Please share its demo or if any documentation released coupled with HANA.

I want to make procedure something like this, please Help

create procedure throw_exception (

          in message string,

          out dummy SYS.DUMMY

          ) language llang reads sql data WITH Result View T_DUMMY  as

begin    

          /* L-procedures must have a return table */

          typedef Table<FixedString<1> "DUMMY"> T_DUMMY;

          export Void main(String message, T_DUMMY &dummy) {

                    throw UserException::QARuntimeException(message);

          }

end;

The SQL Script editor is giving me erros like

Repository: Encountered an error in repository runtime extension;error: UDE:Procedure -> parameters -> type: type not supported: id STRING; xsi:type DataTypes:CharacterStringSQLDataType

Repository: Encountered an error in repository runtime extension;error: UDE:Procedure -> resultviewresult view not supported; please create a table function, will no generate result view _SYS_BIC.

[lbreddemann]

Hello Muhammad,

as Thorsten already and correctly mentioned: L is strictly SAP internal and not meant for any kind of use (not for production, not for teaching/learning, not for anything) outside of SAP.

- Lars

[Former Member]

Lars,

Thanks for reminding me the same twice that i already know. I am a part of SAP and want to develop system for SAP that use L within HANA studio.

I am hoepful that i can use it within SAP.

Amir

[thomas_jung]

Muhammad Aamir Iqbal wrote:
Lars, 
Thanks for reminding me the same twice that i already know. I am a part of SAP and want to develop system for SAP that use L within HANA studio.
I am hoepful that i can use it within SAP.
Amir

Then you should move this discussion to the SAP Internal Community Forums where it belongs.  You shouldn't be asking for details about SAP Internal Only fuctionality on the public forums.

[former_member184768]

And to Thomas and Lars,

Thanks for reminding us mere mortals (Non SAP Employees) that we are not privileged to the divine language of L.

Sorry, but I had this line in my mind since yesterday and didn't dare to put it here. But its weekend now...

Have a good one you all..

Regards,

Ravi