Error in select query in Oracle
I've used a select statement in stored procedure in oracle 11g xe.But an error is showing as

    pls-00428-an INTO clause is expected with select statement

I just cannot understand the error.When i searched i found out that in pl/sql an into clause is needed.I'm using toad.But when i used sql editor same error is showing.

Here's my procedure


    CREATE OR REPLACE PROCEDURE ACTSINFO.sp_Get_WorkDetails
    IS
    BEGIN
     select * from workdetails;
    END sp_Get_WorkDetails;
Error in select query in Oracle
===

I've used a select statement in stored procedure in oracle 11g xe.But an error is showing as

    pls-00428-an INTO clause is expected with select statement

I just cannot understand the error.When i searched i found out that in pl/sql an into clause is needed.I'm using toad.But when i used sql editor same error is showing.

Here's my procedure


    CREATE OR REPLACE PROCEDURE ACTSINFO.sp_Get_WorkDetails
    IS
    BEGIN
     select * from workdetails;
    END sp_Get_WorkDetails;