Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Newbie Question
On 8 Nov, 17:02, "CK" <c_kettenb..._at_hotmail.com> wrote:
Comments embedded.
> Good Morning,
Good evening :)
> I am from SQL Server land.
Welcome to Oracle 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?
How did you learn TSQL? I'm afraid that your post is merely reinforcing the sterotype that a lot of people in this group have with people who've used SQL Server prior to Oracle. Have you tried looking at any Oracle documentation? I'd suggest the following link will help you with your basic syntax issues:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/overview.htm#sthref66
> Thanks,
> ~ck
You're welcome.
HTH -g Received on Thu Nov 08 2007 - 13:45:44 CST
![]() |
![]() |