DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-24347

  1. #1
    Join Date
    Dec 2000
    Posts
    62

    Ora-24347

    os windows2000/9i

    I ran the query via SQL*Plus and got the following error:
    ORA-24347: Warning of a NULL column in an aggregate function

    no rows selecte;


    SELECT vw_explo.fyi_lab_report, vw_explo.fyi_reference_id,
    vw_explo.sys_author, vw_explo.fyi_un_number, vw_explo.fyi_un_ship_name,
    vw_explo.fyi_un_haz_class, vw_explo.sys_keywords,
    vw_explo.fyi_ship_name, vw_explo.sys_title
    FROM vw_explo vw_explo
    WHERE ( (UPPER (vw_explo.fyi_lab_report) = UPPER ('173.56(j)')
    )
    OR (( NOT (SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 15) = UPPER ('u.s. department')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 6) = UPPER ('israel')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 5) = UPPER ('pains')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 8) = UPPER ('ministry')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 6) = UPPER ('morton')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 7) = UPPER ('thiokol')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 4) = UPPER ('taas')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 18) = UPPER ('atlantic research')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 8) = UPPER ('mcdonnel')
    OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 16) = UPPER ('martin marietta')
    )
    )
    AND ( (vw_explo.fyi_un_number = 'UN0093'
    OR vw_explo.fyi_un_number = 'UN0333'
    OR vw_explo.fyi_un_number = 'UN0334'
    OR vw_explo.fyi_un_number = 'UN0335'
    OR vw_explo.fyi_un_number = 'UN0336'
    OR vw_explo.fyi_un_number = 'UN0337'
    OR vw_explo.fyi_un_number = 'UN0349'
    OR vw_explo.fyi_un_number = 'UN0351'
    OR vw_explo.fyi_un_number = 'UN0430'
    OR vw_explo.fyi_un_number = 'UN0432'
    OR vw_explo.fyi_un_number = 'UN0477'
    OR vw_explo.fyi_un_number = 'UN1325'
    OR vw_explo.fyi_un_number = 'NA0323'
    OR vw_explo.fyi_un_number = 'NA0337'
    OR SUBSTR(UPPER(vw_explo.sys_title), 1, 7) = UPPER ('firework')
    OR SUBSTR(UPPER(vw_explo.sys_title) , 1, 5) = UPPER ('trick')
    OR SUBSTR(UPPER(vw_explo.sys_title) , 1, 3) = UPPER ('toy')
    )
    )
    )
    );

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    And the question is?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width