Re: Programatically Accessing Column Length?

[Quoted] [Quoted] jpuopolo_at_bithammer.com (John Puopolo) writes:

> I have a program that scans stored procedure names and parameters -
> this is working fine. My last problem to solve is being able to
> retrieve the max length of a given parameter. For example, given the
> following SP declaration:
>
> PROCEDURE PTest (p_foo IN mytable.mycol%TYPE);
>
> let's suppose that mytable.mycol is a VARCHAR2(255).
>
> When I query the SP parameters via all_arguments, I get back the fact
> that I'm dealing with a VARCHAR, but the length is never filled in.
>
> So, the question is... Is there a way to PROGRAMATICALLY retrieve the
> length of a VARCHAR2 column given only a stored procedure parameter
> whose type is anchored to that column?

You cannot specify the _length_ in procedure or function arguments, so [Quoted] I do not understand why you want to extract this information.

Harald Received on Wed Aug 27 2003 - 11:43:39 CEST