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: Stored Procedure Help

Re: Stored Procedure Help

From: <mgogala_at_rocketmail.com>
Date: Tue, 02 Jun 1998 19:36:51 GMT
Message-ID: <6l1k8j$h4s$1@nnrp1.dejanews.com>


Unfortunately, there is nothing like "argc" in PL/SQL. There are no dynamic parameter lists. If your parameters are all of the same type, then you can use a trick and pass a table (PL/SQL) which can return number of elements.
Hope this helps!
Mladen Gogala
In article <357359EC.63AA12B4_at_sprintmail.com>,   bhom_at_sprintmail.com wrote:
>
> Hi!
>
> Was wondering if anybody knew a quick and dirty way of
> determining the number of parameters passed to a store procedure.
> I know I could set a counter, but is there an easier way?
>
> Thanks much!
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 02 1998 - 14:36:51 CDT

Original text of this message

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