XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • hpl/sql
    • None

    Description

      Hello dear experts,

                I met a block about the Dynamic SQL in hpl\sql.  It can't use this method to generate the correct string:

                DECLARE cur_col_list CURSOR FOR 
                      ' SELECT col_name,col_type FROM ' || v_src_tb || 
                      ' WHERE tb_name = ' || '''' || v_tb_name || '''' ;

               the result as below(missed single quotes on both side of sta_wop_md_op_topic_option :    

               

               but the correct result should be like this:   

               SELECT col_name,col_type
               FROM landing.meta
               WHERE tb_name = 'sta_wop_md_op_topic_option' ;

             

      Attachments

        1. DDL.sql
          0.4 kB
          Johnson
        2. issue_image.jpg
          43 kB
          Johnson
        3. landing.SP_DynamicSQL.proc
          1 kB
          Johnson

        Activity

          People

            dmtolpeko Dmitry Tolpeko
            Johnson_CN Johnson
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: