Results 1 to 4 of 4
  1. #1
    nykel is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default problem with begin on the precedure of Derby

    good morning, i am trying to create a procedure with Derby database base and an error occurs with the "begin" statement.

    the source is like this
    Java Code:
    create procedure SPC_TESTAR()
    begin    
    	select nome from teste
    end
    the error message is like this

    Erro de sintaxe: Encountered "begin" at line 2, column 1.

    thanks for all reply..

  2. #2
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,641
    Rep Power
    7

    Default Re: problem with begin on the precedure of Derby

    See the syntax for procedures CREATE PROCEDURE statement

  3. #3
    nykel is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default Re: problem with begin on the precedure of Derby

    thanks doWhile, i saw the link , eu i studied the sintax but is missing something to understand it.
    have you a simple example? please.
    i ned understand it.
    thanks

  4. #4
    nykel is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default Re: problem with begin on the precedure of Derby

    hi, i am here again

    i got the procedure like this

    CREATE PROCEDURE APP.spc_testde(idade int)
    PARAMETER STYLE JAVA
    LANGUAGE JAVA
    EXTERNAL NAME 'br.com.hrtech.prodedures'

    but where i can put the commands like this

    select * from teste

    thanks

Similar Threads

  1. Derby database problem
    By rjain in forum New To Java
    Replies: 1
    Last Post: 09-22-2011, 12:36 PM
  2. problem with derby driver
    By vitaly87 in forum New To Java
    Replies: 0
    Last Post: 07-16-2011, 01:47 PM
  3. problem with java derby
    By sridarshan in forum JDBC
    Replies: 7
    Last Post: 06-26-2010, 12:17 PM
  4. derby DB problem
    By edi.gotieb in forum Forum Lobby
    Replies: 8
    Last Post: 05-17-2010, 12:45 PM
  5. Is there a problem with Derby?
    By orion_mcl in forum Advanced Java
    Replies: 0
    Last Post: 08-10-2007, 04:35 AM

Posting Permissions

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