when i execute the below package it gives me error insufficient privi
i'm using oracle 10g [toad for sql query]
CREATE OR REPLACE PACKAGE HUMCUST.cs_print_utility
AS
--
-- Useful for Oracle Applications environments
--
PROCEDURE print_output(
p_message IN VARCHAR2
, p_mode IN VARCHAR2 DEFAULT 'LOG');
--
-- PRINT_OUTPUT
--
-- Displays content to DBMS_OUTPUT, but only when g_debug_flag is set to Y .
--
PROCEDURE print_output(p_message IN VARCHAR2, p_size IN NUMBER DEFAULT 250);
--
-- PRINT_OUTPUT
--
-- Displays content to DBMS_OUTPUT, with optional display input parameter
--
PROCEDURE print_output(
p_display_bit IN NUMBER DEFAULT 0
, p_message IN VARCHAR2
, p_size IN NUMBER DEFAULT 250);
p_print_output_mode VARCHAR2(10);
g_debug_flag CHAR(1) := 'N';
END cs_print_utility;
/
when i execute below package then it execute successfully
CREATE OR REPLACE PACKAGE hum_ftp_utilities
IS
PROCEDURE put_remote_file (
errbuf OUT VARCHAR2
, retcode OUT NUMBER
, p_hostname IN VARCHAR2
, p_localpath IN VARCHAR2
, p_filename IN VARCHAR2
, p_remotepath IN VARCHAR2
, p_username IN VARCHAR2
, p_password IN VARCHAR2
, p_filetype IN VARCHAR2 DEFAULT 'ASCII'
, p_mainframe IN VARCHAR2 DEFAULT 'F'
, p_mainframe_command IN VARCHAR2 DEFAULT NULL );
/* USE THIS PROCEDURE TO REMOVE A FILE FROM A REMOTE SERVER LOCATION */
END hum_ftp_utilities;
/
plzz help what's the problem