Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: how to validate incoming pl/sql arguments for type/size? Date: Mon, 07 Jul 2003 22:27:48 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <94599bb3.0307071035.7f7ed94e@posting.google.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 16 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237086 On 7 Jul 2003 11:35:51 -0700, techguy_chicago@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