on 01-30-2017 8:04 AM
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)
)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.