HELP : Store Procedure Question ?

Hi,

Would you please to teach me howw to use INSTR and SUBSTR ??

select INSTR(Name, 'O', 1, 1) from data;

the above query can work well in Oracle, right ?

But, how can I use INSTR and SUBSTR not in a query but in a Store Procdure ?

Such as,

declare

    tmpStr varchar2(50);
begin

    tmpStr := INSTR('Hello Oracle', 'ra', 1, 1); end;

Is it possible ? Please teach me how to implement INSTR and SUBSTR ????

Best regards,
Eric

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_


(((\ \> |/ )                                      ( \| </ /)))


(\\\\ \_/ /   E-Mail : d951686_at_sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \