I was coding "create procedure show_suppliers ...." and the error went away when I changed it to "create procedure show_suppliers() ....". Does that make sense? There are no parms on the method but I saw the parens in a syntax diagram and thought they might be required anyway.
The sample code I am using seems to be full of errors which makes it very hard to learn from. Does anyone have working sample programs that use JBDC and to create, store, and run a SQLJ stored procedure? jstrunk wrote: > > I am using Eclipse 3.5.0 with Derby 10.5.3.0 (not the Derby Plugin). I > created an SQLJ stored procedure and stored it. When I try to execute it I > get SQLException: Syntax error: Encountered "<EOF>" at line 1, column 19. > > That is the only error information I get. How can I get a listing of what > SQL thinks the procedure looks like up to the point where the error > occurs? > -- View this message in context: http://www.nabble.com/SQLException%3A-Syntax-error%3A-Encountered-%22%3CEOF%3E%22-at-line-1%2C-column-19.-tp25638168p25650118.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
