on 03-08-2019 9:30 AM
Hi Folks,
I am not able to capture procedure output in column views. I am giving one simple example.
Below procedure is taking field
VBELN as an input parameter and output parameter is VBAK table.
CREATE PROCEDURE "TestProc" (IN ZVBELN NVARCHAR (10),OUT Z "VBAK")
READS SQL DATA WITH RESULT VIEW "VBAK_TABLE"
AS
BEGIN
Z = SELECT * from "VBAK" where VBELN =:ZVBELN;
END;
Calling Procedure--->
CALL"BEST"."VBAK_TEST098" ('0000016861',z=>?);
I can see the attached Procedure values.
but Coulmn views "VBAk_TABLE" is showing below error--
Error--column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$zvbeln$$. Variable is marked as required but not set in the query
Please suggest ..
Thanks.
As your procedure has a parameter, the generated result view has a parameter too (consider that it is a view and not a persisted result of the procedure result). Because of that you have to supply the parameter when you do a query on the result view. E.g.
SELECT * FROM "BEST"."VBANK_TABLE" ( PLACEHOLDER."$$zvbeln$$" => '0000016861' );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Already done. Just read!
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.