NEED HELP WITH THIS PROCEDURE

From: Dominick LoGiudice <dlogiudice_at_pine.vpcc.sunysb.edu>
Date: Fri, 08 May 1998 22:45:46 -0400
Message-ID: <3553C359.706FFB95@pine.vpcc.sunysb.edu>

When I compile the procedure below I get error messages saying

1):PLS-00428: an INTO clause is expected in this SELECT statement (2):PL/SQL: SQL Statement ignored

How should I code this ?
Thanks

PROCEDURE RUN_SPLIT_TYPE1

   (SELECT_LANG_CODE_IN  IN SPLIT_TABLE.LANGUAGE_CODE%TYPE ,
    SELECT_LEVEL_IN IN SPLIT_TABLE.LEVEL%TYPE,
    SELECT_SPLIT_SET_IN IN SPLIT_TABLE.SPLIT_SET%TYPE,
    SELECT_PARENT_PK_IN IN SPLIT_TABLE.SPLIT_SET%TYPE,
    SELECT_F2_IN IN INITIAL_DATA.F2%TYPE)

   IS

NEXT_LEVEL_VAR SPLIT_TABLE.LEVEL%TYPE; SPLIT_SET_VAR SPLIT_TABLE.SPLIT_SET%TYPE; PARENT_PK_SELECTED_VAR SPLIT_TABLE.PRIMARY_KEY%TYPE;

LANGUAGE_CODE_VAR       SPLIT_TABLE.LANGUAGE_CODE%TYPE;
PRIMARY_KEY_VAR        SPLIT_TABLE.PRIMARY_KEY%TYPE;

MINOFPRIMARY_KEY_VAR SPLIT_TABLE.PRIMARY_KEY%TYPE; BEGIN
-- ABOVE_TYPE_1 SELECT
 DISTINCT (LEVEL+1) AS NEXT_LEVEL,
    -1 AS SPLIT_SET,
    SPLIT_TABLE.PRIMARY_KEY,
 SPLIT_TABLE.LANGUAGE_CODE,
    SPLIT_TABLE.PRIMARY_KEY     FROM SPLIT_TABLE     WHERE SPLIT_TABLE.PRIMARY_KEY <

(SELECT MIN(INITIAL_DATA.PRIMARY_KEY)

                         FROM INITIAL_DATA , SPLIT_TABLE
                       WHERE SPLIT_TABLE.LANGUAGE_CODE =
INITIAL_DATA.LANGUAGE_CODE
                      AND  INITIAL_DATA.PRIMARY_KEY =
SPLIT_TABLE.PRIMARY_KEY
                       AND SPLIT_TABLE.LANGUAGE_CODE =
SELECT_LANG_CODE_IN
                       AND INITIAL_DATA.F2= SELECT_F2_IN
                       AND  SPLIT_TABLE.LEVEL= SELECT_LEVEL_IN
                       AND  SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN
                       AND SPLIT_TABLE.PARENT_PK_SELECTED =

SELECT_PARENT_PK_IN)

     AND   SPLIT_TABLE.LANGUAGE_CODE = SELECT_LANG_CODE_IN
     AND   SPLIT_TABLE.LEVEL = SELECT_LEVEL_IN
     AND   SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN

    AND SPLIT_TABLE.PARENT_PK_SELECTED= SELECT_PARENT_PK_IN union

    SELECT

        DISTINCT (LEVEL+1),
        0 as SPLIT_SET,
     SPLIT_TABLE.PRIMARY_KEY,
        SPLIT_TABLE.LANGUAGE_CODE,
        SPLIT_TABLE.PRIMARY_KEY

    FROM
        SPLIT_TABLE
    WHERE
        SPLIT_TABLE.PRIMARY_KEY =
              (SELECT MIN(INITIAL_DATA.PRIMARY_KEY)
                      FROM INITIAL_DATA , SPLIT_TABLE
                      WHERE SPLIT_TABLE.LANGUAGE_CODE =
INITIAL_DATA.LANGUAGE_CODE
                      AND INITIAL_DATA.PRIMARY_KEY =
SPLIT_TABLE.PRIMARY_KEY
                      AND SPLIT_TABLE.LANGUAGE_CODE =
SELECT_LANG_CODE_IN
                      AND INITIAL_DATA.F2= SELECT_F2_IN
                      AND SPLIT_TABLE.LEVEL= SELECT_LEVEL_IN
                      AND SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN
                      AND SPLIT_TABLE.PARENT_PK_SELECTED =

SELECT_PARENT_PK_IN)     AND

        SPLIT_TABLE.LANGUAGE_CODE = SELECT_LANG_CODE_IN
    AND SPLIT_TABLE.LEVEL = SELECT_LEVEL_IN
    AND SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN
    AND SPLIT_TABLE.PARENT_PK_SELECTED= SELECT_PARENT_PK_IN

UNION SELECT
 DISTINCT (LEVEL+1) AS NEXT_LEVEL, -1 AS SPLIT_SET, SPLIT_TABLE.PRIMARY_KEY,
 SPLIT_TABLE.LANGUAGE_CODE, SPLIT_TABLE.PRIMARY_KEY     FROM SPLIT_TABLE     WHERE SPLIT_TABLE.PRIMARY_KEY >
(SELECT MIN(INITIAL_DATA.PRIMARY_KEY)

                         FROM INITIAL_DATA , SPLIT_TABLE
                       WHERE SPLIT_TABLE.LANGUAGE_CODE =
INITIAL_DATA.LANGUAGE_CODE
                      AND  INITIAL_DATA.PRIMARY_KEY =
SPLIT_TABLE.PRIMARY_KEY
                       AND SPLIT_TABLE.LANGUAGE_CODE =
SELECT_LANG_CODE_IN
                       AND INITIAL_DATA.F2= SELECT_F2_IN
                       AND  SPLIT_TABLE.LEVEL= SELECT_LEVEL_IN
                       AND  SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN
                       AND SPLIT_TABLE.PARENT_PK_SELECTED =

SELECT_PARENT_PK_IN)

     AND   SPLIT_TABLE.LANGUAGE_CODE = SELECT_LANG_CODE_IN
     AND   SPLIT_TABLE.LEVEL = SELECT_LEVEL_IN
     AND   SPLIT_TABLE.SPLIT_SET= SELECT_SPLIT_SET_IN

    AND SPLIT_TABLE.PARENT_PK_SELECTED = SELECT_PARENT_PK_IN; END; Received on Fri May 08 1998 - 21:45:46 CDT