Skip to Content
0

Debug CATALOG SQLScript ( in OR out PARAM missing at position 1 )

Jan 30, 2017 at 08:04 AM

135

avatar image

I have a catalog SQLscript Procedure with the below signature . The Debuger works if I only have the TYPE table as in and OUT parameter, but it gives an error when I mix table type and scalor parameters .

I get an error

CREATE  PROCEDURE SAPABAP1.ZCOPY_SIMP
(
IN I_VIEW SAPABAP1.ZSQL1,
   I_FROM_YEAR NVARCHAR(4),
   I_TO_YEAR   NVARCHAR(4),
OUTE_VIEW SAPABAP1.ZSQL1
)LANGUAGE SQLSCRIPT READS SQL DATA  AS

begin 
.............
end;

and the type table is
CREATE TYPE SAPABAP1.ZSQL1 AS TABLE 
(
CALMONTH2 NVARCHAR (000002),
CALYEAR NVARCHAR (000004),
Z_PROD NVARCHAR (000060),
Z_AMOUNT DECIMAL (000017, 000002),
Z_QUAN DECIMAL (000017, 000003)
)
capture.jpg (22.8 kB)
capture2.jpg (76.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Jan 30, 2017 at 09:58 AM
0

Seems to be an issue of the HANA Dev Tools for Eclipse. I could reproduce the wrong behavior with the latest tools.

As a workaround you can use the Stored Procedure Debug Functionality within the HANA Web-based Development Workbench Catalog View. There the debugging works for procedures with mixed table/scalar input parameters.

Regards,
Florian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks , Web Ide based debugging worked

0