[SPCONV-ERR(<NN>)]:Manual Conversion Required

It is likely that this error is caused by a compute on the end of a query. Compute can be simulated using the CUBE operator in Oracle8i.

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.