Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Newbie Question
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
![]() |
![]() |