Answer Posted / abhishekjaiswal

DECLARE
  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE(my_func + 1);
  END my_proc;




BEGIN  -- main
  my_proc;
END;    -- main
As shown above, with the function declared first you can call the function from the procedure. However, if you try something like the following (function declared before procedure, and function calls procedure):




DECLARE
  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    my_proc;
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE('22');
  END my_proc;




BEGIN  -- main
  DBMS_OUTPUT.PUT_LINE(my_func);
END;    -- main
the compile will fail, because my_func cannot 'see' my_proc. To make it work you need to put in a 'prototype' declaration of my_proc, as follows:




DECLARE
  PROCEDURE my_proc;




  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    my_proc;
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE('22');
  END my_proc;




BEGIN  -- main
  DBMS_OUTPUT.PUT_LINE(my_func);
END;    -- main

What does subquery mean in sql?

986

---

What is faster join or subquery?

957

---

tell me about various levels of constraint. : Sql dba

989

---

what is 'mysqlshow'? : Sql dba

973

---

Define commit?

939

---

Why we use join in sql?

911

---

How to use sql*plus built-in timers?

1093

---

What are %type and %rowtype for?

1009

---

How to take user input in pl sql?

1105

---

How do you update f as m and m as f from the below table testtable?

1784

---

What does select count (*) mean in sql?

959

---

Is sql sequential or random?

980

---

Why do we create views in sql?

1049

---

Can we call stored procedure in function?

903

---

How would you convert date into julian date format?

946

---