Re: Oracle Newbie Question

On Thu, 8 Nov 2007 09:02:59 -0800, "CK" <c_kettenbach_at_hotmail.com> wrote:

>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
>

Three major errors.

1) no parens around arguments
2) specifying param size
3) not SELECTing INTO anything

It would probably be benficial to read the documentation. T-SQL and PL/SQL are different languages, despite their similarities.

B. Received on Thu Nov 08 2007 - 11:16:34 CST