The following example illustrates how the T-SQL to PL/SQL parser in the Migration Workbench could produce this error:
CREATE PROC proc1
AS
declare @mycol1 varchar(30)
select table1.col1,
table2.col2
FROM table1, table2
WHERE table1.id = table2.id
compute max (
col1)
The following code is the PL/SQL code produced by the parser:
CREATE OR REPLACE PROCEDURE
proc1
AS
StoO_selcnt INTEGER;
StoO_error INTEGER;
StoO_rowcnt INTEGER;
StoO_errmsg VARCHAR2(255);
StoO_sqlstatus INTEGER;
mycol1 VARCHAR2(30);
mycol2 VARCHAR2(30);
BEGIN
BEGIN
StoO_rowcnt :=
0;
StoO_selcnt :=
0;
StoO_error
:= 0;
SELECT
table1.col1, table2.col2
INTO proc1.mycol1,
proc1.mycol2 FROM table1, table2
WHERE table1.id
= table2.id
/*[SPCONV-ERR(0)]:MANUAL
CONVERSION MIGHT BE REQUIRED*/
/*COMPUTE MAX(col1)
*/;
StoO_rowcnt :=
SQL%ROWCOUNT;
EXCEPTION
WHEN TOO_MANY_ROWS
THEN
StoO_rowcnt
:= 2;
WHEN OTHERS
THEN
StoO_rowcnt
:= 0;
StoO_selcnt
:= 0;
StoO_error
:= SQLCODE;
StoO_errmsg
:= SQLERRM;
END;
END proc1;
More reporting facilities are available in Oracle Reports and similar reporting tools.