Re: Workspace Manager question

NowhereMan wrote:

> Thanks, that looks very interesting.
> I'm trying to run portions of your demo in SQL*Plus Worksheet.
> This runs as expected:
> SELECT owner, workspace, parent_workspace
> FROM user_workspaces;
> As does this:
> execute dbms_wm.RemoveWorkspace('TryOut2', TRUE);
>
> When I try this snippet, however,
>
> set serveroutput on
>
> DECLARE
> current_workspace VARCHAR2(30);
> current_context VARCHAR2(30);
> current_context_type VARCHAR2(30);
> BEGIN
> dbms_wm.GetSessionInfo(current_workspace,current_context,
> current_context_type);
>
> dbms_output.put_line('Session currently in workspace: '
> || current_workspace);
> END;
>
> I get the error
> dbms_wm.GetSessionInfo(current_workspace,current_context,
> current_context_type);
> *
> 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.

[Quoted] You need to be in SQL*Plus as all of my demos assume that as the tool in use. At the UW we don't let students use any GUI tools so that they will be as proficient on a *NIX machine as on Windoze.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)