Re: Help!!

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 25 May 2006 16:34:01 +0200
Message-ID: <e0gb72tks39aa7o0h48ubtlhkefn3jtkjr_at_4ax.com>


[Quoted] On 25 May 2006 06:26:13 -0700, "Wallace" <princevictor.moses_at_gmail.com> wrote:

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

[Quoted] Just like an ordinary parameter in an ordinary 3GL programming language, as demonstrated in the PL/SQL reference manual.

Does the IQ of developers dwindly that rapidly, or are you just an exceptional case?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu May 25 2006 - 16:34:01 CEST

Original text of this message