Re: PL/SQL Package Spec Meta-Deta

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 19 Jun 1999 18:12:42 +0100
Message-ID: <929812616.10681.1.nnrp-04.9e984b29@news.demon.co.uk>

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.
>
Received on Sat Jun 19 1999 - 12:12:42 CDT