![]() ![]() A block without a name is an anonymous block. When I look at the Debug window and run the statement with -/ and /, I see the following output:ġ5:23:01 executing "select sys_context( 'userenv', 'current_schema' ) from dual"ġ5:23:01 DefaultEditor-5: T4CConnection.createStatement()ġ5:23:01 DefaultEditor-5: OracleStatementWrapper.executeQuery("select sys_context( 'userenv', 'current_schema' ) from dual")ġ5:23:01 Executing.ġ5:23:01 DbConnection='Timesloot Booking - robbram-vm as timeslot' Catalog='null' Schema='null' NewCatalog='null'ġ5:23:01 DbConnection='Timesloot Booking - robbram-vm as timeslot' Catalog='null' Schema='TIMESLOT' NewSchema='TIMESLOT'ġ5:23:01 DefaultEditor-5: OracleStatementWrapper.execute("-/ġ5:23:01 DefaultEditor-5: EXCEPTION -> 圎rrorException: ORA-00911: invalid characterġ5:23:01 DefaultEditor-5: OracleStatementWrapper. A named block is stored into the Oracle Database server and can be reused later. I confirm that in Tools->Tool Properties, select the General->SQL Editor->Statement Delimiters > SQL Block Identifiers: Begin and End identifiers are "-/" and "/". I am running it against an Oracle XE 10 db. anonymous block completed 51182 edited When I try to run below code, I am getting message says: anonymous block completed. For example: BEGIN dbmsoutput. To Display: try using a output statement. When I remove -/ and /, SQL > Execute works but SQL > Execute Buffer fails. 'anonymous block completed' means your PL/SQL code was successfully executed. ![]() 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec ![]()
0 Comments
Leave a Reply. |