Parser Reference Information

The error messages listed in this page contain variable entries for number, procedure name, and string. These variables are represented by <NN>, <NAME>, and <STRING> respectively.

Click these errors for information about why they occur and what can be done to avoid them.

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)],oracle.mtg.sqlserver7.parser.ParseException:Parse error at line <NN>, column <NN>. Encountered: <STRING>

[SPCONV-ERR(<NN>)] FETCH <STRING> is not supported in Oracle

[SPCONV-ERR(<NN>)]:('Raiserror ( num') Manual conversion might be required num gives id in SQL Server SYSCOMMENTS table

[SPCONV-ERR(<NN>)]:(FULL OUTER JOIN) Manual conversion might be required

[SPCONV-ERR(<NN>)]:(LIKE) if using '[' Manual conversion might be required

[SPCONV-ERR(<NN>)]:(WITH <STRING>) ignored. Manual conversion may be required

[SPCONV-ERR(<NN>)]:(set) Manual conversion might be required

[SPCONV-ERR(<NN>)]:BEGIN TRAN statement ignored

[SPCONV-ERR(<NN>)]:CREATE INDEX <STRING> statement ignored

[SPCONV-ERR(<NN>)]:CREATE TABLE <STRING> statement passed to DDL file

[SPCONV-ERR(<NN>)]:CREATE VIEW <STRING> statement ignored

[SPCONV-ERR(<NN>)]:DROP PROCEDURE <STRING> statement ignored

[SPCONV-ERR(<NN>)]:DROP TABLE <STRING> statement ignored

[SPCONV-ERR(<NN>)]:DROP VIEW <STRING> statement ignored

[SPCONV-ERR(<NN>)]:GRANT statement ignored

[SPCONV-ERR(<NN>)]:INSENSITIVE CURSOR is not supported in Oracle

[SPCONV-ERR(<NN>)]:Manual conversion required

[SPCONV-ERR(<NN>)]:ORDER BY statement ignored

[SPCONV-ERR(<NN>)]:One or more columns are procedure variables for table -- <STRING>

[SPCONV-ERR(<NN>)]:Parsing[(<NAME>)]('<STRING>':Global Variable treated as variable

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]('LEFT JOIN') Complex OUTER JOINs are not reliably converted

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]('RIGHT JOIN') Complex OUTER JOINs are not reliably converted

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]('SCROLL CURSOR') is not supported in Oracle

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]:(LIKE .. INNER) Manual conversion might be required)

[SPCONV-ERR(<NN>)]:ALTER TABLE <STRING> statement ignored

[SPCONV-ERR(<NN>)]:(UPDATE.. SET..=(SELECT..)) Manual conversion required

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]('CURSOR ..<NAME>') is not supported in Oracle

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]To reduce locking add columns explicitly to FOR UPDATE clause on cursor: <NAME>

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]:(OUTER|RIGHT|LEFT JOIN) Manual conversion required

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)]:Formatting arguments truncated. STR(<NAME>,<NN>,<NN>

[SPCONV-ERR(<NN>)]:[Parsing(<NAME>)] (CASE..END) Parser failed on a statement, restarting to continue with next statement