I am trying to write a simple stored procedure for oracle. My first
in oracle :-(
This procedure will take one parameter from an asp page. That is
login. This is my attempt at the sp

CREATE or replace PROCEDURE osp_Username_select_intr_not

(Login in varchar2)

AS
Begin
Select TUD_NAME, TUD_Email from Tab_User_Details Where TUD_Login =
Login ;
End;

I am using toad to develop this. Toad is sending an error which
states "PLS-00428: an INTO clause is expected in this SELECT
statement"

What am I missing? I don't want to select into anything.

Thanks
Mike

Mike D wrote:
Because you did not specify in/out parameters you need a variable to
place the result of your select statement.

select field into variable from table where x=y;

Michael Austin.