Re: Want to test my MAP function

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Mon, 24 Nov 2003 10:10:43 +0000
Message-ID: <LzOCk7Ajkdw$Qx$f@peterfinnigan.demon.co.uk>

Hi James,

You got the objects built then!, read the error it tells you exactly what is wrong. Your select returns more than one row of data and you are trying to place it into one variable. Either restrict the select to return just one row or implement a loop and loop through each of the values returned.

Kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Mon Nov 24 2003 - 04:10:43 CST