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

Home -> Community -> Usenet -> c.d.o.misc -> Help!!

Help!!

From: Wallace <princevictor.moses_at_gmail.com>
Date: 25 May 2006 05:24:36 -0700
Message-ID: <1148559875.983161.147720@i39g2000cwa.googlegroups.com>


Hai All,

  I am new to oracle.
  I created a package with one function, as follows

SPEC:



 create or replace PACKAGE "PACKAGE_MAIN" AS
   FUNCTION              "TEST"

(Empid NUMBER) RETURN INTEGER;
  END; BODY:

create or replace PACKAGE BODY "PACKAGE_MAIN" AS
FUNCTION              "TEST"

(Empid NUMBER)

 RETURN INTEGER AS
    --performing a select using empid in where clause  END; My question is "How to give value for that empid?"

Looking forward for the response...
Thanx in advance... Received on Thu May 25 2006 - 07:24:36 CDT

Original text of this message

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