Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Warning: Procedure created with compilation errors

1056203Nov 23 2013 — edited Nov 24 2013

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2013
Added on Nov 23 2013
4 comments
1,196 views