Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to pass value to a function inside package?
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"END; body as
(EMP_ID NUMBER) RETURN INTEGER;
CREATE OR REPLACE PACKAGE BODY "PACKAGE_TEST" AS
FUNCTION "FUNC_TEST"--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?
(EMP_ID NUMBER) RETURN INTEGER AS
Please help!!!
Looking forward for the response...
Thanx in advance..
Received on Fri May 26 2006 - 02:40:22 CDT