2 Replies Latest reply: May 11, 2014 12:02 PM by Andreas Weiden RSS

    From clause query

    salute-Salem

      hi ,

      i am using this query in a from clause

      SELECT PM.PATIENT_FILE_NO,
             PE.EPISODE_NO,
             DECODE(CURRENT_LANG_P_S,
                    'P',
                    PATIENT_NAME_P || ' ' || PATIENT_NAME_2_P || ' ' ||
                    PATIENT_NAME_3_P || ' ' || PATIENT_NAME_F_P,
                    PATIENT_NAME_S || ' ' || PATIENT_NAME_2_S || ' ' ||
                    PATIENT_NAME_3_S || ' ' || PATIENT_NAME_F_S) PATIENT_NAME,
             PE.START_DATE,
             PE.END_DATE,
             EXSYS.GET_AGE(PM.DATE_OF_BIRTH) AGE,
             CODES_PKG.GET_DESCRIPTION(PM.GENDER, 103) GENDER,
             PE.ATTENDANCE_TYPE,
             PATIENT_CATEGORY
        FROM RC_PATIENTS PM, RC_PATIENT_EPISODES PE
       WHERE PM.PATIENT_FILE_NO = PE.PATIENT_FILE_NO
         AND PE.STATUS != 'C'
      
      

      The query works well in "pl/sql Developer" but when i run the form i got "Query caused no records to be retrieved"  

      -- i wrote

      go_block('block_name') ;

      execute_query ;

      in a w-n-f-i trigger

      - i have items compatible with number and names of the retrieved columns of the query , but i have more items in the same block

      ??