Can a procedure contain only a SELECT statement?

From: Thomas Gagne <TandGandGAGNE_at_gmail.com>
Date: Wed, 17 Mar 2010 21:53:57 -0400
Message-ID: <tqadnRsfhsIjGjzWnZ2dnUVZ_qudnZ2d_at_wow.com>

I'm looking around for Oracle 10g CREATE PROCEDURE syntax and looking for examples with simple SELECT statements inside. I see a lot of DML but none with simple SELECT statements.

I'm thinking something like

create or replace procedure aSimpleSelect (aLikeValue char(4)) as begin
select *
  from aTableName
 where aColumn like aLikeValue;
end;
/

But when I try creating it inside 10g it complains:

PLS-00103: Encountered the symbol "(" when expecting one of the following: :=), default varying character large the symbol ":=" was substituted for "(" to continue. Received on Wed Mar 17 2010 - 20:53:57 CDT