nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Call procedure/sql before executing query with params

Carlos Carvalho

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:

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

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet