Confuse about the 'Open Session Command' usage
For Oracle type data connection, when we query data from the physical data tables, we need specify the schema in the query code. Now we want to use 'Open session command' to specify the schema, and then we can remove the schema from the query code.
Everything goes well until we meet one information link, whoes SQL code has 'Pre-Updates' query, and we meet the exception 'PLS-00201: identifier 'ESP_DBVIEW_UTILS.SET_CONTEXT_INFO_NV' must be declared'.
We are confused why the 'Open session command' doesn't work for the 'Pre-Updates' query?
If you know why or how to resolve this situation, pelase tell me. I will be apreciate.