Re: Oracle Newbie Question

On Nov 8, 11:45 am, "CK" <c_kettenb..._at_hotmail.com> wrote:
> 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

You've declared an OUT parameter and not supplied it. Try this at the SQL> prompt:

variable reslt number
exec searchThis2('Here is my search string', 'c', :reslt); print reslt

You should get successful completion and a result value.

David Fitzjarrell Received on Thu Nov 08 2007 - 14:08:35 CST