4 Replies Latest reply: Jan 8, 2013 8:16 AM by salute-Salem RSS

    what is wrong with this code ?

    salute-Salem
      declare
           new_node ftree.node ;
           dnames varchar2(90) ;
           deptnos number ;
           cursor dept_cur is
           select dname ,deptno from dept ;
      begin
           loop
                fetch dept_cur into dnames ,deptnos ;
                exit when dept_cur%notfound ;
           end loop ;


      new_node := ftree.add_tree_node('b.tree4',
      ftree.root_node,
      Ftree.PARENT_OFFSET,
      Ftree.LAST_CHILD,
       Ftree.EXPANDED_NODE, 
      dnames ,
      null,
      deptnos
      );
      end ;

      Edited by: semsem on Jan 8, 2013 3:41 AM
        • 1. Re: what is wrong with this code ?
          Marwim
          what is wrong with this code ?
          Shouldn't you be able to tell us what is wrong? Does it not work as expected, doesn't it compile?

          Marcus

          BTW: you can use
           tags around your code to preserve formatting and make the code more readable.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
          • 2. Re: what is wrong with this code ?
            salute-Salem
            the code does not compile .
            • 3. Re: what is wrong with this code ?
              Marwim
              the code does not compile .
              Without error message?

              Come on, you have 631 posts and you still don't know that we need more that a simple "it does not work" to help you ;-)

              Marcus
              • 4. Re: what is wrong with this code ?
                salute-Salem
                i want to close this one , because the code is compiled now after rewriting it from scratch , but sure i can not close it .
                2- i can ask more than one question , what is the problem with that ?
                3- you could help me with the two .