How can I add source code to a stored procedure?

Hello,

I model my database with an ER-diagram.
I have 2 stored procedures modeled yet and want to get them functional, i.e. I want to add their logic.

How can I accomplish this as they have to do some fairly complex calculation.

With kind regards

Florian Reiser

Hello Florian,

Thank you for your post. I regret that we support only modeling but not the generation of stored procedure. Your request has been forwarded to our team for further feasibility studies. Once there is any feedback, we will inform you immediately.

Best regards,
Jick

Hello Jick,

thanks for your fast reply.
I offer you to test it, when it becomes available.

With kind regards

Florian Reiser

Hello Florian,

How about we provide an additional text box for user to enter the implementation?

Best regards,
Jick

Hello Jick,

I think that would be a good idea in the first step.
In the second step maybe there could some kind of syntax highlighting.

Additionally there should be some kind of language selector. Think of Oracle, where you can choose between PL/SQL and Java.

Finally the stored procedure / stored function / package should be generated, which I can’t get to work until now, too.

With kind regards
Florian Reiser

Hi Florian,

Thank you for your feedback. I will pass it onto our developers.

Best regards,
Jick