Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
SELECT prvtemx_sql.alter_analysis_task_xml(2, 'zonemap
task', 1)
FROM dual;
ERROR:
ORA-20000: invalid action type
ORA-06512: at "SYS.PRVTEMX_SQL", line 650
ORA-06512: at "SYS.PRVTEMX_SQL", line 611
ORA-06512: at line 1
prvtemx_sql.creative_analysis_task(
task_name IN VARCHAR2,
description IN VARCHAR2,
sts_owner IN VARCHAR2,
sts_name IN VARCHAR2,
show_sql_only IN NUMBER)
RETURN XMLTYPE;
A DBMS_SQLPA analysis parameter was tried with the result shown
prvtemx_sql.report_set_analysis_dflts_xml(spa_defaults IN VARCHAR2);
exec prvtemx_sql.report_set_analysis_dflts_xml('<SQL PERCENTAGE="10">');
BEGIN prvtemx_sql.report_set_analysis_dflts_xml('<SQL PERCENTAGE="10">'); END;
*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at "SYS.PRVTEMX_SQL", line 2107
ORA-06512: at line 1
prvtemx_sql.schedule_analysis_compare(
task_id IN NUMBER,
task_name IN VARCHAR2,
execution_name IN VARCHAR2,
description IN VARCHAR2,
execution_name1 IN VARCHAR2,
execution_name2 IN VARCHAR2,
comparison_metric IN VARCHAR2,
start_date IN TIMESTAMP WITH TIME ZONE,
show _sql_only IN NUMBER)
RETURN XMLTYPE;
prvtemx_sql.schedule_analysis_execution(
task_id IN NUMBER,
task_name IN VARCHAR2,
exsecution_name IN VARCHAR2,
description IN VARCHAR2,
execution_type IN VARCHAR2,
start_date IN TIMESTAMP WITH TIME ZONE,
show_sql_only IN NUMBER)
RETURN XMLTYPE;
prvtemx_sql.schedule_quick_check_task(
change_spec IN VARCHAR2,
task_name IN VARCHAR2,
description IN VARCHAR2,
time_limit IN VARCHAR2)
RETURN VARCHAR2;