Hi, I am creating simple sp, see below script
CREATE OR REPLACE PROCEDURE uspGetClient
AS
BEGIN
SELECT * FROM Client WHERE Active = 1;
END ;
I am getting-
Warning: Procedure created with compilation errors
when i am seeing the --> show errors i am getting below
PLS-00428: an INTO clause is expected in select statement
so does this mean we cannot create sp for select statement or what, can you give me solution for above?
Thanks
Raviranjan