Re: Help: WebDB

From: <schipper_at_frg.eur.nl>
Date: Tue, 14 Sep 1999 13:49:15 GMT
Message-ID: <7rljom$i4h$1@nnrp1.deja.com>

In my experience you can only use stored procedures when they have been granted to the public role....

In article <7rkvuu$24ia$1_at_stargate1.inet.it>, "Carlo Goldoni" <cgoldoni_at_etnoteam.it> wrote:
> Hi, everybody.
>
> Is there anybody who can tell me how to build a form based on a stored
> procedure?
>
> I logged in as "WEBDB" and created a new user, named BR1, giving it
> Browse-In and Build-In privilges on its schema.
>
> Then, as BR1, I created two simple tables (for test only) and a stored
> procedure which copies records from one table to the other. Finally, I
tried
> to build a form based on this procedure, but something went wrong: in
the
> second step of the wizard, I could not find the procedure in the
> "selection-list" box !
>
> Please, help me!
>
> Thanks in advance,
> Carlo Goldoni
>
> Email: cgoldoni_at_etnoteam.it
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 08:49:15 CDT