Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Unanswered: what will be the output please????

    hi all,

    Study the following Code.

    Create or replace package pkg_test As

    Variable1 Number;
    Procedure Proc1 ..
    Procedure Proc2

    End;
    Create or replace package body pkg_test As

    Variable2 Number;

    Procedure Proc1..
    ---------------
    ---------------------
    Procedure Proc2
    ------------------
    --------------------------
    Procedure Proc3
    ------------------
    --------------------------
    End;


    If the following statement is submitted what will be the result?
    Execute pkg_test. Proc3;

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: what will be the output please????

    Why didn't you just run it and see?

    It will be something like:

    *
    ERROR at line 1:
    ORA-06550: line 1, column 16:
    PLS-00302: component 'PROC3' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •