Re: Oracle Newbie Question

From: CK <c_kettenbach_at_hotmail.com>
Date: Thu, 8 Nov 2007 09:45:25 -0800
Message-ID: <oYHYi.4397$RR6.3038@newssvr22.news.prodigy.net>

ok I got it fixed, but what am I doing wrong in calling the procedure?

Final proc:
CREATE OR REPLACE PROCEDURE searchThis2
 (m_stringToSearch varchar, m_search char, result out integer) AS
BEGIN SELECT INSTR(m_stringToSearch ,m_search , 1,1) INTO result FROM DUAL;

END;
/

I am trying to call it like this. I am using the Express 10g edition and using the web sql commands tool provided with the install.

BEGIN
searchThis2('Here is my search string', 'c'); END; I get the error:

ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'SEARCHTHIS2'
ORA-06550: line 2, column 1:

PL/SQL: Statement ignored1. BEGIN
2. searchThis2('Here is my search string', 'c'); 3. END; What am i missing here? Thanks for your help all! ~ck Received on Thu Nov 08 2007 - 11:45:25 CST