What SQL Server version is this? Can you post the T-SQL function signature of [f_FolderName]? How did you create the DSLContext (e.g. any particular Settings)?
2013/6/28 Venkat Sadasivam <[email protected]> > The below code gives error. > Record record = > transaction.getContext().select(Routines.fFoldername(3333)).fetchAny(); > > org.jooq.exception.DataAccessException: SQL [select [f_FolderName](?)]; > Incorrect syntax near '@P0'. > at org.jooq.impl.Utils.translate(Utils.java:1021) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:287) > at > org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:329) > at > org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:320) > at org.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:453) > at org.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:1073) > > Any help? > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
