Skip to Content

Not able to capture procedure data in to column views

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.

proc1.png (4.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 08 at 11:31 AM

    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' );
    Add comment
    10|10000 characters needed characters exceeded