i have problems executing an process flow out of sql developer with an different user than the workspace owner.
Although i have executed exec owbsys.wb_workspace_management.set_workspace('OWBWORKSPACE','WORKSPACEOWNER'); before trying to start the process flow out of sql developer, i get the following error:
ORA-20008: The workspace with name:OWBWORKSPACE and owner:EXECUTIONUSER does not exist. You can find out the existing workspace information from view ALL_IV_WORKSPACE or view WORKSPACE_ASSIGNMENT. ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1602 ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1569 ORA-06512: at "OWBSYS.WB_RT_SCRIPT_UTIL", line 1028 ORA-06512: at "WORKSPACEOWNER.START_PROCESSES", line 31 ORA-06512: at line 3
We use OWB 22.214.171.124.
One more information, in my pl/sql procedure (START_PROCESSES) i have the following line owbsys.wb_rt_script_util.set_workspace ('OWBWORKSPACE');