Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12

    Question Unanswered: Errors in the simplest procedures in Progress

    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
    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?

  2. #2
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12

  3. #3
    Join Date
    Jan 2011
    Posts
    1
    Quote Originally Posted by Indarija View Post
    Thanks for sharing! It helped me solve my problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •