Unable to Activate analytic privilege

[Former Member]

Hi,

I am getting an exception when I activate the analytic privilege which I have created.

Here are the steps I followed:

Step 1) Created a new analytic privilege and added a calculation view ("cv_my_cal_view") (This view has a field called user_id)

Step 2) In the "Associated Attribute Restrictions" section, selected the same calculation view and added the attribute (user_id).

Step 3)In the "Assign Restrictions" I selected the

               type as "Repository Procedure",

               operator: "Equal" and

               value: MY_SCHEMA.mypackage::GET_USER

The problem is when I activate the created privilege, it throws an error pop-up saying

"Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Repository procedure does not provide enough scalar output params for comparison operator"

The stored procedure executes fine when I run it using sql console.

Here is the stored procedure code:

PROCEDURE "MY_SCHEMA"."mypackage::GET_USER" (

OUT out_current_user VARCHAR(30) )

  LANGUAGE SQLSCRIPT

  SQL SECURITY INVOKER

  DEFAULT SCHEMA "MY_SCHEMA"

  READS SQL DATA AS

BEGIN

  SELECT CURRENT_USER INTO out_current_user FROM dummy;

END;

Please help me in understanding what is going wrong with this approach.

Thanks in advance.

Regards,

Aditya

[Former Member]

Hi Kumar,

You need to change the operator to IN.

Regards,

Sumit

[Former Member]

Hi Aditya,

First of all you can have a look at

Regarding your problem, your stored procedure should be the repository procedure instead of catalog procedure, right? So, please try mypackage::GET_USER instead of MY_SCHEMA.mypackage::GET_USER

Best regards,

Wenjun

[Former Member]

Hi Wenjun,

Tried using "mypackage::GET_USER".

It still gives the same exception.

Regards,

Aditya