Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insufficient privi

747821Aug 23 2010 — edited Aug 24 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2010
Added on Aug 23 2010
3 comments
716 views