This discussion is archived
4 Replies Latest reply: Jan 8, 2013 6:16 AM by newbi_egy RSS

what is wrong with this code ?

newbi_egy Explorer
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 ?
    newbi_egy Explorer
    Currently Being Moderated
    the code does not compile .
  • 3. Re: what is wrong with this code ?
    Marwim Expert
    Currently Being Moderated
    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 ?
    newbi_egy Explorer
    Currently Being Moderated
    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 .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points