On Friday, June 2, 2017, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Friday, June 2, 2017, anand086 <anand086@gmail.com> wrote:
Another example where we are getting the same error is from the call of the
below code --
ctx.update(""
+ "begin \n"
+ "
access.register_type( \n"
+ "
p_entity_system => ?, \n"
PostgreSQL doesn't alllow named arguments when calling functions and function calls must be part of a SQL statement: select func(?,?,?,?.?); this applied even to functions that do not return results. IOW, PostgreSQL doesn't have stored procedures.
Guess I should have re-read the docs.
Named arguments are a thing so the main problem is that you don't have a select before your function name. Though I would have expected a different error message...
David J.