Re: Oracle Newbie Question

On Thu, 8 Nov 2007 09:45:25 -0800, "CK" <c_kettenbach_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 really ought to read the documentation. That's where you will find that Oracle reccomends to not use VARCHAR. There are also samples that will help you.

Start with the SQL Reference.

B. Received on Thu Nov 08 2007 - 13:03:37 CST