Xref: alice comp.databases.oracle.misc:33965 Path: alice!news-feed.fnsi.net!news.idt.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.misc Subject: Re: PL/SQL Package Spec Meta-Deta Date: Sat, 19 Jun 1999 18:12:42 +0100 Message-ID: <929812616.10681.1.nnrp-04.9e984b29@news.demon.co.uk> References: <7kecvd$spv$1@nnrp1.deja.com> <376BB53B.88ACC1F5@ditw.com> X-Trace: news.demon.co.uk 929812616 nnrp-04:10681 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 36 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@ditw.com>... >desc package_name.procedure_name > >-- Alton > >jeperkins4@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. >