![]() 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. 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. This video show how to use the debugger to step through the Anonymous PLSQL Block. todays and tomorrows date): anonymous block completed Hello World TODAY IS. I confirm that in Tools->Tool Properties, select the General->SQL Editor->Statement Delimiters > SQL Block Identifiers: Begin and End identifiers are "-/" and "/". 1 Answer Sorted by: 1 You are mixing metaphors here. Oracle Database 11g: PL/SQL Fundamentals A - 2 General Notes: Save all. I am running it against an Oracle XE 10 db. i can see anonymous block completed as the result. The parameter value can be set as a NET Framework type, ODP.NET type, or as an ODP.NET LOB object type. We need to enable DBMSOUTPUT by clicking on plus symbol to see the output. Updating LOBs Using OracleCommand and OracleParameter To update LOB columns, LOB data can be bound as a parameter for SQL statements, anonymous PL/SQL blocks, or stored procedures. 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. When I remove -/ and /, SQL > Execute works but SQL > Execute Buffer fails. I executed this PL/SQL block without errors but i cannot see the result. Since an ANONYMOUS PL/SQL BLOCK is a program that has no name and is not stored in the database, we must have a way to say that it has executed when testing such a program. I executed this PL/SQL block without errors but i cannot see the result. 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec
0 Comments
Leave a Reply. |