Hi Karthikeyan,
So you want to use what jOOQ calls "plain SQL" to execute your stored
procedures:
http://www.jooq.org/doc/latest/manual/sql-building/plain-sql/
Unfortunately, right now, there is only limited support for plain SQL when
calling stored procedures. You can try MySQL's own syntax like this
(assuming you're using MySQL):
DSL.using(configuration)
.execute("CALL my_procedure('param-1', 2, 'param-3')";
See:
http://dev.mysql.com/doc/refman/5.5/en/call.html
Unfortunately, you won't be able to register OUT parameters this way. In
that case you will have to resort to using JDBC
Regards,
Lukas
2014-03-28 12:44 GMT+01:00 Karthikeyan Ravi <[email protected]>:
> Hi Lucas,
>
> I have created routines to execute pre-defined procedures for my
> application.
> But, the enduser of my application can able to create procedure for his
> own requirement, now
> i want to execute the procedures created by the enduser dynamically on a
> button event.
>
> Is there any solution to execute the procedures created by enduser without
> creating routines?
>
> Thanks
>
> Karthikeyan.
>
>
> On Friday, 28 March 2014 17:02:41 UTC+5:30, Lukas Eder wrote:
>
>> Hi Karthikeyan,
>>
>> I thought I might not have entirely understood your requirement :-)
>>
>> 2014-03-28 12:21 GMT+01:00 Karthikeyan Ravi <[email protected]>:
>>
>> Hi Lucas,
>>>
>>> Thanks for your reply, I am sorry i didn't explain my requirement
>>> clearly in my post.
>>>
>>> The requirement is for some part of the procedures i am using Routine to
>>> execute it. But for some of
>>> the procedures are created endusers through the application and that has
>>> to be executed without
>>> creating routine. I need both ways to execute the procedure.
>>>
>>
>> You mean as in using "plain SQL", no jOOQ-generated artefacts?
>>
> --
> 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/d/optout.
>
--
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/d/optout.
