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 -> Re: How to pass value to a function inside package?

Re: How to pass value to a function inside package?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 May 2006 11:15:03 +0200
Message-ID: <snhd72ttqtc1u9b21tll34jgleemi22aul@4ax.com>


On 26 May 2006 00:40:22 -0700, "Wallace" <princevictor.moses_at_gmail.com> wrote:

>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..

http://tahiti.oracle.com PL/SQL reference manual.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri May 26 2006 - 04:15:03 CDT

Original text of this message

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