Store procedure

[dev ch, modificado hace 12 años.]

Hi all,

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

[jelmer kuperus, modificado hace 12 años.]

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

[Hitoshi Ozawa, modificado hace 12 años.]

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 hace 12 años.]

Thank you.

[ashish pradhan, modificado hace 12 años.]

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

yes, i want stored proceudure in service builder

[David H Nebinger, modificado hace 12 años.]

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 hace 12 años.]

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