Re: Workspace Manager question
Date: Thu, 3 Feb 2005 07:57:17 -0500
Message-ID: <11047td8h92319a_at_corp.supernews.com>
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
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 - 13:57:17 CET