Re: Oracle Newbie Question

"CK" <c_kettenbach_at_hotmail.com> schreef in bericht news:oYHYi.4397$RR6.3038_at_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
>

Your proc has 3 parameters, and you call it with 2 as it is a fucntion. Try this:

CREATE OR REPLACE fucntion searchThis2
> (m_stringToSearch IN varchar2, m_search varchar2) return number
> AS
> BEGIN
> return INSTR(m_stringToSearch ,m_search , 1,1) ;
> END;
Shakespeare Received on Thu Nov 08 2007 - 13:37:06 CST