Store procedure

[dev ch, modificado 12 Anos atrás.]

Hi all,

Can any body have any idea about what is store procedure in portlet? Please help me out with details?

[jelmer kuperus, modificado 12 Anos atrás.]

You mean a stored procedure ? that has nothing to do with portlets. If not what do you mean ?

[Hitoshi Ozawa, modificado 12 Anos atrás.]

I've answered in the following thread.

http://www.liferay.com/community/forums/-/message_boards/message/13237534

or do you want to use stored procedure with service builder?

[dev ch, modificado 12 Anos atrás.]

Thank you.

[ashish pradhan, modificado 12 Anos atrás.]

Actually what is the Storde procedure portlet? i dont have any idea

yes, i want stored proceudure in service builder

[David H Nebinger, modificado 12 Anos atrás.]

This is doable, but can take a lot of work on your end depending upon what the stored proc is doing.

If you're retrieving data to be returned as an entity, you would create an entity in service.xml and build the services. You'd then go to the ***LocalServiceImpl class and either add methods to invoke the SP separately or override the generated methods if you have to invoke the SP to do those operations.

Oh, and there is no "stored procedure portlet", it doesn't exist.

[Hitoshi Ozawa, modificado 12 Anos atrás.]

I haven't tried this myself yet, but it may be doable by writing up procedure in default.xml in custom-sql folder.

http://www.liferay.com/ja/documentation/liferay-portal/6.1/user-guide/-/ai/custom-sql