Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Newbie Question

Oracle Newbie Question

From: CK <c_kettenbach_at_hotmail.com>
Date: Thu, 8 Nov 2007 09:02:59 -0800
Message-ID: <DkHYi.4395$RR6.3122@newssvr22.news.prodigy.net>


Good Morning,
I am from SQL Server land. I am trying to create a simple stored proc and I can not get it right. What is wrong with this statement?

CREATE OR REPLACE PROCEDURE searchThis
 m_stringToSearch varchar(255), m_search char(1) AS
BEGIN
SELECT INSTR(m_stringToSearch ,m_search , 1,1) FROM DUAL; END; I get Encountered the symbol "end-of-file" when expecting one of the following:

   begin function package pragma procedure form

What am I missing here?
Thanks,
~ck Received on Thu Nov 08 2007 - 11:02:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US