Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement PostgreSQL Error

 
Vic Hood
Ranch Hand
Posts: 477
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
Im trying to write sample stored functions in postgresql and call them using the CallableStatement offered by JDBC.

Here's some my test code

And my Stored function is of the form .


However, I'm getting the following error when I try to run the code .


Any idea on why this is happening would be appreciated.

 
Vic Hood
Ranch Hand
Posts: 477
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anyone ? Im kinda stuck with this
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm only guessing here, but I don't think it's possible to call a function like it was a stored procedure. In MS SQL Server it's certainly not allowed. Try calling it like this:
 
Martin Vajsar
Sheriff
Pie
Posts: 3751
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rob Spoor wrote:I'm only guessing here, but I don't think it's possible to call a function like it was a stored procedure. In MS SQL Server it's certainly not allowed.

It should work. It definitely works in Oracle. Actually, this is why escaping (the curly braces) must be used, it allows the JDBC driver to rewrite and process the query as required by its database.

However, your advice is certainly worth to try, if the direct call doesn't work with MS SQL, other databases might be affected too.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic