Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Call procedure/sql before executing query with params

Question
1
Views
0
Comments
Carlos Carvalho
Carlos Carvalho Rank 6 - Analytics & AI Lead
in Oracle Analytics Cloud and Server

Summary

Call procedure/sql before executing query with params

Content

Hello experts,

I am new in BIP.

I have a weblogic with bip (12.2.1.3.0  (build:20170720.0424) ) installed.

I want to execute a method/procedure ( alter session set current_schema = :parameter_schema; ) before the sql query, so it will retrieve the data in the desired schema.

insert a sql procedure in the data set, but it gives error;

I am having this:

image

In WL server i have no logs about this error.

What is the best way to achieve this?

I have searched in this forum for answers, but did not found anything marked correctly. Can you help me?

Thanks and Regards,

Carlos

Message was edited by: managed BEAN