Stored Proc Question

I'm looking for help in creating a stored procedure to do the following:

• 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

PsuedoCode would be like the following:

   Get_Records ( Tm as Date/Time)

            Connect User/Password;
            Select * from table where date >= Tm;

This procedure would be executed by a desktop application like MS-Access or Delphi, so the application would need to see the results as a table or view.

Thanks for any help,

Mark DeWaard
mark-dewaard_at_uiowa.edu Received on Tue Sep 23 1997 - 00:00:00 CDT