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 is crud stand for?

992

---

What is union and union all keyword in sql?

1027

---

What does (*) mean in sql?

945

---

What do you understand by case manipulation functions?

1026

---

What is bulk collect in pl sql?

1086

---

What are joins in sql?

1037

---

Why do we need cursor in pl sql?

1125

---

What is partition by in sql?

1059

---

How to install oracle sql developer?

1039

---

What is an ndf file?

985

---

Explain select statements in sql?

1049

---

explain the difference between bool, tinyint and bit. : Sql dba

984

---

Is progress software supports to ( pl/sql )?

1033

---

What is the purpose of the primary key?

1055

---

What are the disadvantages of file system?

1252

---