| "WWUTL_API_SecurityTransport" abnormality [message #182332] |
Fri, 14 July 2006 06:53  |
mfran2002
Messages: 8
Registered: July 2006
|
Junior Member |
|
|
hi,
i'm trying to restore on a backup server an oracle portal 8.1.7 db
no problem for generic users but qhen i have to restore portal30 or portal30_sso schema everything goes to....
now i'm trying with secexp and ssoexp (secimp, ssoimp) utilities
but i have the following problem:
secexp.cmd utilities run this command line:
%ORACLE_HOME%\bin\sqlplus %portal_schema%/%portal_password% @utlsecxp.sql %global_priv%
and utlsecxp.sql runs:
WWUTL_API_SecurityTransport.Initialize;
WWUTL_API_SecurityTransport.BeginExtract;
WWUTL_API_SecurityTransport.ExtractSecurity('&1');
WWUTL_API_SecurityTransport.EndExtract;
BUT it returns this errors:
Extracting Security Data to transport tables...
WWUTL_API_SecurityTransport.Initialize;
*
ERROR at line 4:
ORA-06550: line 4, column 5:
PLS-00306: wrong number or types of arguments in call to 'INITIALIZE'
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
ORA-06550: line 5, column 33:
PLS-00302: component 'BEGINEXTRACT' must be declared
ORA-06550: line 5, column 5:
PL/SQL: Statement ignored
ORA-06550: line 6, column 33:
PLS-00302: component 'EXTRACTSECURITY' must be declared
ORA-06550: line 6, column 5:
PL/SQL: Statement ignored
ORA-06550: line 7, column 33:
PLS-00302: component 'ENDEXTRACT' must be declared
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
in fact package WWUTL_API_SecurityTransport does not have the previous procedure, it has the following procedures:
create or replace package WWUTL_API_SecurityTransport as
-- utility development routines
procedure StartExport
(
p_export_id in varchar2,
p_global_priv in varchar2 default 'OFF',
p_only_person in boolean default false
);
procedure StartImport
(
p_export_id in varchar2,
p_MergeMode in varchar2 default 'check',
p_UserMode in varchar2 default 'database_user'
);
procedure Initialize
(
p_export_id in varchar2,
p_export_name in varchar2
);
procedure ExtractMetaData
(
p_export_id in varchar2,
p_export_name in varchar2,
p_global_priv in varchar2 default 'OFF'
);
end WWUTL_API_SecurityTransport;
IT'S NORMAL THAT IT WILL NEVER RUNS!!!!
BUT WHY I HAVE THIS PROBLEM???
HELP ME PLEASE!!!!!
thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
