Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Workspace Manager question

Re: Workspace Manager question

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 03 Feb 2005 19:12:25 -0800
Message-ID: <1107486581.587891@yasure>


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.

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)
Received on Thu Feb 03 2005 - 21:12:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US