Re: PL/SQL Package Spec Meta-Deta

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

Jonathan Lewis wrote:

> For use with Java/SQLJ, you will probably have to call
> the underlying packaged procedure which is
> dbms_describe.desribe_procedure() defined in the
> script $ORACLE_HOME/rdbms/admin/dbmsdesc.sql
>
> You will also have to use the declared types in that
> package to get return (OUT) values, so you may
> want to write a package in the database that (say)
> converts the OUT types to a more SQLJ-friendly
> structure.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Alton Ayers wrote in message <376BB53B.88ACC1F5_at_ditw.com>...
> >desc package_name.procedure_name
> >
> >-- Alton
> >
> >jeperkins4_at_my-deja.com wrote:
> >
> >> Does anyone know a good way to query the package specifications in a
> >> describe like manner where you could get back the parameters and
> >> datatypes per function and/or procedure?
> >>
> >> The goal is to provide Java via SQLJ with some kind of idea of the
> >> datatypes that
> >> would return from calling a PL/SQL package.
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Share what you know. Learn what you don't.
> >

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_
(((\ \> |/ )                                      ( \| </ /)))
(\\\\ \_/ /   E-Mail : d951686_at_sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \