Re: WebDB selection from dual...how to?

I'm not sure if this would work, but how about creating a view against the log table, which selects records where user_name=user. Then build the webdb form against the view.

Webdb definitely handles updatable views OK.

Peter

Win Ker wrote:
>
> I'm creating a web-based running log using WebDB 2.1.0.9.3. The premise
> is that each registered user will be able to log in and enter data ONLY
> under their own username account, and view ONLY under their own
> logged-in account. I've tried creating a stored procedure to determine
> the user's current login session username simply using (along with an
> insert statement which passes v_user as the username to register the
> transaction under) "select user into v_user from dual;", then link the
> procedure as a WebDB Procedure component...this all works fine, except
> the value returned from dual is always the role <schema>_PUBLIC, instead
> of the username! Not good...
>
> If I take the same procedure and create a "PL/SQL call" as a QuickLink
> in WebDB, it works fine, returning the proper login account
> name...<scary music starts>
>
> To date, I've had to create separate "insert" and "view" forms for EACH
> user, hardcoding the user account right into the form as the "WHERE
> clause"...pretty kludgey.
>
> Anyone have an idea of how to retrieve the value of the current session
> username...obviously dual won't work for this one.
>
> Thanks muchly!
Received on Tue Sep 21 1999 - 10:37:08 CDT