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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to validate incoming pl/sql arguments for type/size?

Re: how to validate incoming pl/sql arguments for type/size?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 07 Jul 2003 22:27:48 +0200
Message-ID: <qsljgvcg8j62ih2hbbnra3b3a8ubv79aps@4ax.com>


On 7 Jul 2003 11:35:51 -0700, techguy_chicago_at_yahoo.com (Bomb Diggy) wrote:

>
>Can a column '%TYPE' be passed as an argument to a function?

You'll need to have a TYPE declaration outside the procedure, so in a package. The TYPE declaration can of course use %TYPE

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 07 2003 - 15:27:48 CDT

Original text of this message

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