Re: Workspace Manager question
Date: Thu, 3 Feb 2005 07:57:17 -0500
Thanks, that looks very interesting.
[Quoted] I'm trying to run portions of your demo in SQL*Plus Worksheet. This runs as expected:
SELECT owner, workspace, parent_workspace
As does this:
execute dbms_wm.RemoveWorkspace('TryOut2', TRUE);
When I try this snippet, however,
set serveroutput on
current_workspace VARCHAR2(30); current_context VARCHAR2(30); current_context_type VARCHAR2(30);
dbms_output.put_line('Session currently in workspace: '
END; I get the error
ERROR at line 6:
ORA-06550: line 6, column 9: PLS-00302: component 'GETSESSIONINFO' must be declared ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
Why is GetSessionInfo unrecognized?
Thanks for your help.
> The best way I can think of is to read the concept docs
> at http://tahiti.oracle.com and run the full demo at
> http://www.psoug.org ... click on Morgan's Library ...
> click on Workspace Manager.
Received on Thu Feb 03 2005 - 13:57:17 CET