VERIFIED SOLUTION i
Product Feature: Errors
While calling a procedure using “SQLExecuteStoredProc” an error is encountered ''ORA-06650: line 1, column 7: PLS-00201:identifier 'domain:procedure' must be declared''.
This could be caused due to:
- Oracle user (used in PD) does not have execute permission on this procedure.
- Stored procedure is invalid (i.e not compiled successfully).
ResolutionUPDATED: September 27, 2017
Ensure stored procedure is executed successfully from a Oracle client (for example SQL Developer) with oracle user, used with Portrait Dialogue.