Errors in the simplest procedures in Progress

Indarija · #1 (**permalink**) 12-28-10, 08:50

Hi,
I work with the Progress OpenEdge database (10.1C if I am correct). I use the program "OpenEdge Architect." It's all new to me. I've never worked with this database.

I could build a database connection and I have also created a few tables on the SQL Editor.

Now I want to do procedures, but it does not work. The simplest procedures is not accepted:

Code:

CREATE PROCEDURE Test01() 
BEGIN
    String message = 'Hello World'; 
END

Error:
[DataDirect]OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "END" (10713)

I have found the following:

http://communities.progress.com/pcom...01c_readme.pdf

Quote:

When you create a Java trigger in the SQL editor, you must add an additional
space before the carriage return after each semicolon. Otherwise, a syntax error
may be displayed: 'syntax Error in SQL statement at or about "End". (10713)
Note: OE00163095 Type: Behavior Change
Database connections available for import/export only after clicking OK

It describes my problem. But is not the solution. I've tried it, but it did not work.

You may have another idea?