in 11.5 can't view nested cursors in date grid

Wendy Penfold <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
When I run the following query with nested cursors in the editor, I can 
view the first level of nested cursor by double clicking (CURSOR), but 
not subsequent levels--although it does pop up the 'Cursor Edit' window, 
like it is trying...  It was a while ago, but I do remember being 
impressed that this feature worked in a prior version of Toad.

SELECT Szbstdn_pidm,
                   Szbstdn_num_semesters_adj,
                   Szbstdn_housing_id,
                   Szbstdn_icpeer_username,
                   Q1.Szbques_code,
                   Q1.Szbques_order,
                   Q1.Szbques_required || ' ' || Q1.Szbques_label 
Szbques_label,
                   Q1.Szbques_question_text,
                   Q1.Szbques_control_type,
                   Q1.Szbques_footnote,
                   Q1.Szbques_filter_label,
                   CURSOR (
                        SELECT Q2.Szbques_sub_order,
                               Q2.Szbques_question_text,
                               CURSOR (
                                    SELECT Szbansw_answer_number,
                                           Szbansw_label,
                                           Szbansw_answer_text,
                                           Szbansw_default_answer,
                                              Szbansw_ques_code
                                           || '#;;#'
                                           || Szbansw_ques_sub_order
                                           || '#;;#'
                                           || Szbansw_answer_number
                                           || '#;;#'
                                              Update_key
                                      FROM Szbansw A
                                     WHERE     A.Szbansw_ques_code = 
Q2.Szbques_code
                                           AND Q2.Szbques_sub_order =
A.Szbansw_ques_sub_order
                                           AND NOT ( A.Szbansw_ques_code =
'CAMPUSAREA'
                                                    --FRESHMAN CANT LIVE 
IN APARTMENTS_
                                                    AND 
A.Szbansw_answer_number IN
                                                           (5, 6)
                                                    AND 
G.Sgbstdn_styp_code = 'F')
                                  ORDER BY A.Szbansw_ques_sub_order,
                                           A.Szbansw_answer_number)
                                  Options,
                               CURSOR (
                                  SELECT Szsprfl_answer_number, Answer_text
                                    FROM Szqansw R
                                   WHERE     R.Szsprfl_pidm = S.Szbstdn_pidm
                                         AND R.Szsprfl_ques_code = 
Q2.Szbques_code
                                         AND Q2.Szbques_sub_order =
R.Szsprfl_ques_sub_order)
                                  Responses
                          FROM Szbques Q2
                         WHERE     Q1.Szbques_code = Q2.Szbques_code
                               AND Q2.Szbques_control_type <> 'RANK'
                               AND NOT (    Q2.Szbques_code = 'CAMPUSAREA'
                                        --FRESHMAN CANT LIVE IN APARTMENTS_
                                        AND Q2.Szbques_sub_order IN (5, 6)
                                        AND G.Sgbstdn_styp_code = 'F')
                      ORDER BY Q2.Szbques_order,
                               Q2.Szbques_sub_order NULLS FIRST)
                      Questions
              FROM Sgbstdn G, Szbstdn S, Szbques Q1
             WHERE     G.Sgbstdn_pidm = P_pidm
                   AND G.Sgbstdn_pidm = S.Szbstdn_pidm
                   AND G.Sgbstdn_term_code_eff =
                          (SELECT MAX (B.Sgbstdn_term_code_eff)
                             FROM Sgbstdn B
                            WHERE     G.Sgbstdn_pidm = B.Sgbstdn_pidm
                                  AND B.Sgbstdn_term_code_eff <=
                                         ithaca.szhousterm ())
                   AND Sgbstdn_stst_code = 'AS'
                   AND Szbques_sub_order = 0
          ORDER BY Q1.Szbques_order



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.