Re: Workspace Manager question

From: NowhereMan <nowhere_at_man.com>
Date: Thu, 3 Feb 2005 07:57:17 -0500
Message-ID: <11047td8h92319a@corp.supernews.com>

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.
Received on Thu Feb 03 2005 - 06:57:17 CST