I've been using the JDeveloper 10g tool for PL/SQL development lately and find that though Quest Software's TOAD allows PL/SQL debugging in an integrated development environment (IDE), Oracle's JDeveloper 10g PL/SQL debugger offers more features, starts faster, and is easier to use.
Much of...
Is the SQL as simple as you say or does it rely on collection types? in-line views? or other constructions like a CAST operator? Did the RETURNING use a BULK COLLECT clause?
You didn't say whether you're using 10.1 or 10.2... I'm finding more flexibility in 10.2.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.