Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help on stored procedure

Re: Help on stored procedure

From: skv <skv_at_kpbank.ru>
Date: 1997/09/30
Message-ID: <01bccd43$75a23980$0bc47cc1@skv.hq.kem>#1/1

        hi Chialin
You can use DESCRIBE command in SQL*Plus

SQL> DESC my_stored_proc

Regards


         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru

Chialin Chou <chichou_at_ximage.com> çàïèñàíî â ñòàòüþ <342FD08E.1AAD2712_at_ximage.com>...
> Is there a way that I can query the parameter names and the data types
> of a stored procedure?
> Thanks.
>
> Chialin Chou
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> chichou_at_ximage.com
>
>
Received on Tue Sep 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US