Programatically Accessing Column Length?

[Quoted] [Quoted] I have a program that scans stored procedure names and parameters - [Quoted] 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 [Quoted] 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 [Quoted] that I'm dealing with a VARCHAR, but the length is never filled in.

[Quoted] So, the question is... Is there a way to PROGRAMATICALLY retrieve the [Quoted] length of a VARCHAR2 column given only a stored procedure parameter [Quoted] whose type is anchored to that column?

Any help appreciated.

Thanks,
John Received on Tue Aug 26 2003 - 15:38:25 CEST