You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Lon Varscsak <lo...@gmail.com> on 2019/05/06 22:34:37 UTC

Stored Procedures

Is there anyway to specify that an Object Entity uses a stored_procedure to
fetch its data?

-Lon

Re: Stored Procedures

Posted by Lon Varscsak <lo...@gmail.com>.

If the entity isn't a real table and only exists for the purpose of an sp
call, how do I setup that Entity?

On Mon, May 6, 2019 at 11:20 PM Andrus Adamchik <an...@objectstyle.org>
wrote:

> Not at the model level. But you can write a ProcedureCall query to fetch
> an entity.
>
> Andrus
>
> > On May 7, 2019, at 1:34 AM, Lon Varscsak <lo...@gmail.com> wrote:
> >
> > Is there anyway to specify that an Object Entity uses a stored_procedure
> to
> > fetch its data?
> >
> > -Lon
>
>

Re: Stored Procedures

Posted by Andrus Adamchik <an...@objectstyle.org>.

Not at the model level. But you can write a ProcedureCall query to fetch an entity.

Andrus

> On May 7, 2019, at 1:34 AM, Lon Varscsak <lo...@gmail.com> wrote:
> 
> Is there anyway to specify that an Object Entity uses a stored_procedure to
> fetch its data?
> 
> -Lon