ORA-20013: The workspace has not been set when querying view
Hi everybody,
i created a view to get informations about a my process flows.
The view contains informations like how many rows are selected and inserted and which mappings where executed.
The view worked fine unleast i upgraded my owb to 11gR2.
Now when i want to query the view i get following error
ORA-20013: The workspace has not been set. Please call wb_workspace_management.set_workspace procedure to set workspace first. Or you can go to OWB Client Console and under menu Tool/Preference you can change your default workspace to a valid workspace within Environment prefrence group then whenever you login to database your valid default workspace will be automantically set.
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1690
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1725
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1740
I checked the default workspace under OWB Client Tools --> Preferences. The right workspace is selected there.
So can anybody help me out of this?
One thing: in my pl/sql procedures i use owbsys.wb_rt_script_util.set_workspace ('WS_NAME'); to change to the right workspace. But i don't know who to use this in a view.
Greetings,