Question Re: Debug CATALOG SQLScript ( in OR out PARAM missing at position 1 ) in Technology Q&A

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

rmuhuri — Mon, 30 Jan 2017 08:04:56 GMT

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)
)

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

pfefferf — Mon, 30 Jan 2017 09:58:50 GMT

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

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

rmuhuri — Mon, 30 Jan 2017 17:28:26 GMT

Thanks , Web Ide based debugging worked