VERIFIED SOLUTION i

Resolve error 'ORA-06650: line 1, column 7: PLS-00201:identifier 'domain:procedure' must be declared' in Portrait Dialogue

Product Feature: Errors
 

Issue

While calling  a procedure using “SQLExecuteStoredProc” an error is encountered ''ORA-06650: line 1, column 7: PLS-00201:identifier 'domain:procedure' must be declared''.
 
Dialog_SQL_Procedure_Error_1.PNG
 
Dialog_SQL_Procedure_Error_Error.PNG

Cause

This could be caused due to:
  1. Oracle user (used in PD) does not have execute permission on this procedure.
  2. Stored procedure is invalid (i.e not compiled successfully).

Resolution

UPDATED: September 27, 2017
Ensure stored procedure is executed successfully from a Oracle client (for example SQL Developer) with oracle user, used with Portrait Dialogue.