Unable to use an IQD created in Framework Manager that contains an Oracle stored procedure

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.