1 Reply Latest reply on May 14, 2013 2:29 PM by user8950278

    Problems executing an processflow out of sqldeveloper with different user

      Hi everybody,

      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 line 3

      We use OWB
      One more information, in my pl/sql procedure (START_PROCESSES) i have the following line owbsys.wb_rt_script_util.set_workspace ('OWBWORKSPACE');

      I hope anybody can helo me out of this.