ForĬause: Usually a PL/SQL compilation error. Not sure if I'm doing something wrong or if its a Oracle SQL developer setting. The fact is that your block doesn't result valid for the PL/SQL compiler, and your error is there to tell you, and is coming out from the PL/SQL compiler and not from the Sql Developer!Ĭause: The INTO clause of a SELECT INTO statement was omitted. Started running an anonymous block but I get PL/SQL procedure successfully completed instead of 'anonymous block completed'. I’m guessing your scripts are going to be a bit more complicated than mine, but this serves as a decent example to get you started. This video covers the anonymous blocks in depth with creation and execution of the anonymous blocks in the sql developer. Please help set serveroutput on declare shape constant char (20):square area real (6) side constant number (6):2 pi constant number (4,2):3. i can see anonymous block completed as the result. I run the following package in sql developer but always come out ' anonymous block completed' I would like to what is 'anonymous block completed' Is it an error What we need to bear in mind BEGIN PKGVERIFICATION2.SPCHK () END 1 - 4 Locked Post New comments cannot be posted to this locked post. Inside the procedure, I have an INTO for that select, but is there a simple way that I can simply get the results for the last SELECT statement for my debugging? I'm using anonymous block and variables so that the code is as similar as possible from what's actually inside the procedure, so that I don't have to change the code set serveroutput on format wrapped ĭBMS_OUTPUT.PUT_LINE('v_dt_max = ' || v_dt_max) ĭBMS_OUTPUT.PUT_LINE('v_dt_min = ' || v_dt_min) įrom tb_cad_cliente a join tb_trn_transacao bĪnd b.dt_row between v_dt_min and v_dt_maxįor what I know, whatever tool you use to debug, the pl/sql blocks(anonymous and named) should be valid for the PL/SQL compiler. The Anonymous Block is opened in a new SQL Dev page You can now step through the block, using watches and breakpoints as expected. I executed this PL/SQL block without errors but i cannot see the result. PLS-00428: an INTO clause is expected in this SELECT statement However you do not really need dynamic SQL for what you are doing, just make the lcursor1 type as an out parameter. You either need to use all dynamic SQL syntax here or none at all. I would like that SQL Developer simply return the last SELECT statement, but I get the error: ORA-06550: line 21, column 5: 1 Answer Sorted by: 1 You are mixing metaphors here. I'm trying to debug a SELECT inside a procedure, and I'm trying to this using a anonymous block.
0 Comments
Leave a Reply. |