Can a procedure contain only a SELECT statement?
Date: Wed, 17 Mar 2010 21:53:57 -0400
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
where aColumn like aLikeValue;
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