Skip to Content
1

SAP Hana XSA Web IDE:: SQLSCRIPT Unresolved function "record_count"

Nov 17, 2017 at 05:16 PM

98

avatar image

Hi,

I try to use record_count in a stored procedure but get always the error msg: Unresolved function "record_count".

The hdiconfig is up to date.

{
    "plugin_version" : "2.0.20.0",
    "file_suffixes" : {


declare lv_index integer;

ltCases = SELECT "PATNR"
	FROM "TBASE.db.NDSO.etlTaskChain::ndsoKennzahl5.ndsoKennzahl5.active_data";
FOR lv_index IN 1..record_count(:ltCases) DO

END FOR;

I can build this stored procedure, but if I call it, I get this error:

Could not execute 'CALL "dummy.db.procedures.csp::test"()'
Error: (dberror) general error: SQLScript internal error: N9sqlscript10ScalarTypeE is not derived from N9sqlscript4TypeE

Any ideas

10 |10000 characters needed characters left characters exceeded

the same for issue: Unresolved function IS_EMPTY

It cames with SPS11, a long time ago. why do I have this issue?

IF IS_EMPTY(:lt_Kennzahl) THEN
          RETURN;     
END IF;

Any ideas?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers