Re: Oracle Newbie Question

Can you help me fix it?
CREATE OR REPLACE PROCEDURE searchThis2
 (@stringToSearch varchar(255), @search varchar(1)) IS
BEGIN SELECT INSTR(@stringToSearch ,@search , 1,1) FROM DUAL;

END; Now i get Encountered the symbol "@" when expecting one of the following

Yes, T-SQL is much easier. This looks to be a bit tougher. Thanks for your help.

"Brian Tkatch" <N/A> wrote in message
news:9ug6j3ltd2lh7ou1akj19q8k52n9iub97p_at_4ax.com...
> 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:18:15 CST