Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

User defined scalar function returns zero rows

Hi,

I have created the following simple function.

CREATE FUNCTION FUNCTION_MUL(IN_VAR INT)

RETURNS RESULT INT LANGUAGE SQLSCRIPT

AS

BEGIN

RESULT := :IN_VAR * :IN_VAR;

END;

I call this function as  SELECT FUNCTION_MUL(2) as RESULT FROM DUMMY;

I always get zero errors returned.

Kindly help me in resolving it.

Thanks & Regards,

Monissha

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question