I want to check if column value is null and return false accordingly.
Code:
create or replace
PROCEDURE SP_PPO_VALIDATION(
pi_var_workitem_id IN VARCHAR2,
po_char_flag OUT CHAR,
po_var_tab OUT VARCHAR2)
AS

l_cur_basic SYS_REFCURSOR;
l_int_count NUMBER;
cnt NUMBER;
l_var_col_name VARCHAR2(50);
l_cur_financial SYS_REFCURSOR;
desc_tab DBMS_SQL.DESC_TAB;

BEGIN
  
  OPEN l_cur_basic FOR
  SELECT PENSION_TYPE,
  TITLE,
  FIRST_NAME,
  MIDDLE_NAME,
  LAST_NAME,
  NAME,
  GENDER,
  NATIONALITY,
  PHONE_NUMBER,
  MOBILE_NUMBER,
  PAN,
  EMAIL from tbl_ppo_basic_temp WHERE workitem_id= pi_var_workitem_id;
   cnt := DBMS_SQL.to_cursor_number(l_cur_basic);
   DBMS_SQL.DESCRIBE_COLUMNS(cnt, l_int_count, desc_tab);
 
   FOR i IN 1..l_int_count LOOP
   l_var_col_name:=desc_tab(i).col_name;
  DBMS_OUTPUT.PUT_LINE(l_var_col_name);

   END LOOP;
   
  
  EXCEPTION
  when OTHERS THEN
  dbms_output.put_line(sqlerrm);
END SP_PPO_VALIDATION;
this is for fixed fields but columns in cursor may vary.. I've to check each value and return false if null. So as m reading column_name in loop Iwant to read the value of that column. Please Help