Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to pass value to a function inside package?

How to pass value to a function inside package?

From: Wallace <princevictor.moses_at_gmail.com>
Date: 26 May 2006 00:40:22 -0700
Message-ID: <1148629222.649547.64570@i39g2000cwa.googlegroups.com>


Hai All,

  I am very new to oracle.
  I have wrote a package as follows

  specification as

  CREATE OR REPLACE PACKAGE "PACKAGE_TEST" AS

  FUNCTION              "FUNC_TEST"

(EMP_ID NUMBER) RETURN INTEGER;
  END;   body as

  CREATE OR REPLACE PACKAGE BODY "PACKAGE_TEST" AS

  FUNCTION              "FUNC_TEST"

(EMP_ID NUMBER) RETURN INTEGER AS
    --here i am doing a select using EMP_ID in the where clause   END;   Please tell how to run this package from SQL DEVELOPER?   Also I want give the value for EMP_ID in the specification as default..how can i give(for example EMP_ID as 1200?

  Please help!!!
  Looking forward for the response...
  Thanx in advance.. Received on Fri May 26 2006 - 02:40:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US