Skip to Content
0

Error executed PAL procedure in SQL Script calculation view

Oct 11, 2017 at 10:44 AM

20

avatar image

Hello

I create SQL Script calculation view. In this view i used PAL method CROSTON

If i activated view I got an error:

Short Text
Insufficient privileges - not authorized
Cause
User is not authorized to deploy attribute view
Recommendations
Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"

I executed :

GRANT SELECT ON SCHEMA USER1 TO _SYS_REPO WITH GRANT OPTION

And give my user roles:

  • AFL__SYS_AFL_AFLPAL_EXECUTE
  • AFL__SYS_AFL_AFLPAL_EXECUTE_WITH_GRANT_OPTION

But error was saved.

If i executed method CALL "USER1"."CROSTON_TEST_PROC"() in SQL console then everything was fine, i got data.

View code:

/********* Begin Procedure Script ************/ 
 BEGIN 
 in_data2 = select * FROM "USER1"."PAL_CROSTON_DATA_TBL";
in_parameter2 = select * FROM "USER1"."PAL_CONTROL_TBL3";
 
 CALL "USER1"."CROSTON_TEST_PROC"(:in_data2, :in_parameter2, result2, PAL_CROSTON_STATISTICS_TBL);
  
   var_out = SELECT  TIME, OUTPUT FROM :result2;

END /********* End Procedure Script ************/

I get an error

afl
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers