krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 26th, 2008

 

Yes , we can. Here is simple example.

CREATE OR REPLACE PROCEDURE TEST_PROC(V_NUM OUT NUMBER) AS
BEGIN
V_NUM := 10;
END;
/

CREATE OR REPLACE FUNCTION TEST_FUNC RETURN NUMBER  AS
V_NUM NUMBER;
BEGIN
TEST_PROC(V_NUM);
RETURN V_NUM;
END;
/

SELECT TEST_FUNC() FROM DUAL;

OUTPUT
10

raman

• Jan 3rd, 2017

 

good example this program if you write select query statement

sudha

• Aug 4th, 2017

 

No