Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to pass value to a function inside package?
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 DBAReceived on Fri May 26 2006 - 04:15:03 CDT