Now, a person can have more than one education as I want to display some fields in a table format for which I use anonymous pl/sql block. Other than that, it seems that you need a stored function What you could do is to increase your sort_area_size which can help you to overcome the performance Bug.įor example: alter session set sort_area_size = 64000 Well you can't do this using an sql not stored function. However, when I try to do it I get the error 'function 'GET_PAYMENT_DATES' is not usable in SQL.ĭoes anyone know of a workaround? I'm trying to avoid having to store this function. I want to call the function from the cursor and function will essentially have an ID as parameter and will return a list of values comma separated. I need to create an anonymous block that contains a cursor and function. PL/SQL anonymous block - try to call the function within cursor How we refer the anonymous block in PL/SQL? And what is the purpose of anonymous blocks? Can offer no alternative workaround, that packing horror XML in a view. The analysis has been the problem indeed. TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Productionģ.0.04 (Buld Main 04.34 with bundled Java) on a Window's XP box. My environment: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production Overlooking the comments of K, it seems that debugging has worked for 'simple' blocks, so I wonder if it's just out of reach. Is this a problem with my environment or there's a problem with SQL Developer 3.0.04. XMLTABLE() it fails (a normal SELECT INTO works very well). the moment this is in the block "Debug" is no longer an optionĬOLUMNS SendDocumentResult varchar2( 1000 ) PATH 'SendDocumentResult' ) Įnd The moment that I SELECT INTO. So I started to whittle my anonymous block to the bottom to find the culprit, here's a breaking point repeatable for me: declare This has nothing to my anonymous block but has worked well for a simple example. I found this forum:Īnd Vadim Tropashko follow-up advice. The "Debug" is grayed out and the string 'ctrl-SHIFT-F10' key did nothing. So I immediately tried to debug an anonymous block (something I was not looking to do in EA versions) and nothing happened. I used EA versions because they have emerged and was happy to see the final version. I just downloaded the Oracle SQL Developer 3.0. Oracle SQL Developer 3.0: Debugging of PL/SQL anonymous blocks: ISSUES
0 kommentar(er)
