Re: Stored Proc Question

From: Steve Kerns <steve_kerns_at_cargill.com>
Date: 1997/09/25
Message-ID: <342ABAD4.C67F855B@cargill.com>#1/1

A small problem exist with this scheme. Oracle stored procedures cannot return
multiple rows. This is a feature that Sybase has but Oracle doesn't and I miss it.

I think a view would work better in this case.The view gets the owners permissions and
the view's user get the permission assigned by the owner.

Steve

Mark DeWaard wrote:

> <stuff deleted>
> - Use a different login id and password using PL/SQL connect command
> This allows the user to have different rights than his/her login id
> - send back the results of a select query with a variable for the
> where
> clause
> <stuff deleted>
>
Received on Thu Sep 25 1997 - 00:00:00 CDT