In Transformer, when trying to open an IQD created in Framework Manager that contains an Oracle stored procedure, you may receive a message similar to the following:
(TR0118) Transformer can't read the database [datasource] defined in <Lan location>\<datasource><iqd_name>
.iqd. DMS-E_General A general exception has occurred during operation 'execute' The native SQL generated in an IQD created in Framework Manager is wrong. The IQD cannot be used in Transformer.To resolve this problem, execute the stored procedure in Framework Manager and set the
Externalize Method to IQD. Create a model query subject from the executed stored procedure, then publish the package and open it in Transformer
