I know that there is a way to call a stored procedure by Hibernate.
Is there a way to create a stored procedure as well?
I need to create a stored procedure dynamically in Pl/PsgSQL and then storing it the db with hibernate.
Example:
I have a form with a text area so a user can write pl/PsgSql code inside
When the user submits the form , the code has to be stored as a procedure in the db.
I'd would be great if I could check also the pl/PsgSql syntax, if possible.
As for PL/SQL syntax, Hibernate can't do that. You can either display any SQL error that comes back or you could use something like antlr with a PL/SQL grammar.
