0 Replies Latest reply: Sep 24, 2013 4:53 AM by b558ceb4-75c3-4c36-9703-45433423d4a9 RSS

    stored procedure exexcution problem

    b558ceb4-75c3-4c36-9703-45433423d4a9

      hi , to all

       

      I am not getting , that how to execute any stored procedure in oracle 11 g sql work sheet

      i could not execute not even a simple one stored procedure

      like for example , i have a proc

       

      Create or replace procedure print_proc

      as

      BEGIN

        print 'abc';

      END;

       

      command execute succesfully .

       

      Now if i want to execute my procedure by any command like this

       

      begin

      print_proc;

      end;

       

      It is giving me error like this

       

      ORA-06550: line 2, column 19: PLS-00905: object SYSTEM.PRINT_PROC is invalid ORA-06550: line 2, column 1: PL/SQL: Statement ignored https://192.168.1.61:5500/em/cabo/images/t.gif

       

      I have also tried by putting execute keyword ,, but problem is coming also there  ..

       

       

      Somebody please suggest me any view for this headache ,

      thanks in advance