ORA-01722 (Invalid Number) When Fetching Data from Cursor [message #258188] |
Fri, 10 August 2007 09:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
TheodoreB
Messages: 1 Registered: August 2007 Location: Eau Claire, WI
|
Junior Member |
|
|
While converting a form from 6i to 10g, I've come across this error. The code that is causing the problem is as follows:
DECLARE
Dummy_Define CHAR(1);
CURSOR SYSTEM_VARIABLES_cur IS
SELECT 1 FROM SYS_VARS S
WHERE S.VAR_NAME = :PP.PPI;
BEGIN
OPEN SYSTEM_VARIABLES_cur;
FETCH SYSTEM_VARIABLES_cur INTO Dummy_Define;
IF ( SYSTEM_VARIABLES_cur%found ) THEN
Message('Error ...');
CLOSE SYSTEM_VARIABLES_cur;
RAISE Form_Trigger_Failure;
END IF;
CLOSE SYSTEM_VARIABLES_cur;
END;
The line that is causing the problem is the FETCH line.
Any help is greatly appreciated.
TIA,
--TB
|
|
|
|
|