I just downloaded the latest version of Oracle SQL Developer, because I heard that it is free and comes with a debugger.
So I have it all setup, I am connected to my database, but I wanted to execute a simple example:
I selected to create a new Procedure and a new tab opened up, I pasted this code and under DBMS Output, I clicked the + to: set serveroutput on
CREATE OR REPLACE PROCEDURE TEST1 As
DECLARE
mytext varchar2(100) := 'Hello world!' ;
BEGIN
dbms_output.put_line(mytext) ;
dbms_output.put_line(mytext) ;
END TEST1;
Yes, I know I posted the put_line twice, it should print Hello World twice ? same error with 1 line, when I remove the duplicate.
yet, I see this message in the Log: "Source does not have a runnable target."
And when I try to compile, I see 2 errors:
Procedure ORCL_SQL_DEVE_TEST1@CONNECTION
Error(2,1): PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: begin function package pragma procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current cursor external language The symbol "begin" was substituted for "DECLARE" to continue.
Error(6,10): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe
I am using Oracle SQL Developer version: Version 2.1.1.64