Store procedure

[dev ch, geändert vor 12 Jahren.]

Hi all,

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

[jelmer kuperus, geändert vor 12 Jahren.]

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

[Hitoshi Ozawa, geändert vor 12 Jahren.]

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, geändert vor 12 Jahren.]

Thank you.

[ashish pradhan, geändert vor 12 Jahren.]

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

yes, i want stored proceudure in service builder

[David H Nebinger, geändert vor 12 Jahren.]

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, geändert vor 12 Jahren.]

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