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 -> Re: Oracle Newbie Question

Re: Oracle Newbie Question

From: gazzag <gareth_at_jamms.org>
Date: 8 Nov 2007 11:45:44 -0800
Message-ID: <1194543356.285138.111750@s15g2000prm.googlegroups.com>


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

Original text of this message

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