SQL*Report Messages:RPT-0000 to RPT-0078:RPT Error Messages And Codes
SQL*Report Messages:RPT-0000 to RPT-0078:RPT Error Messages And Codes
RPT-0000too few arguments
One of the RPT commands does not have enough arguments, or contains a carriage return. For example, a macro with no name:
.DEFINE SELECT empno, ename
INTO empno, ename
FROM emp
..
RPT-0001argument overflowRPT-0002illegal variable or macro name
This error indicates that a variable has been declared or a macro has been defined with an illegal name. The rules for naming variables and macros are on p.59.
RPT-0003illegal label name
This error indicates that a label has been used which has an illegal name. The rules for naming statement labels are on p.59.
RPT-0004formatting: no room to insert commasRPT-0005".." command while not in macro
This error will occur if a two periods (..) are found on a line by themselves, outside of a macro. This indicates the completion of a macro definition. (p.101-2)
RPT-0006*** No digits or decimals specifiedRPT-0007*** Too many suffixesRPT-0008label multiply defined in macro
This error will occur if the report uses the same label name more than once in the same procedural macro. Since label definitions are local, the same label name may be used in different macros. Also, only the first 30 characters of an identifier name are significant. (p.59,115)
RPT-0009macro has already been defined
This error will occur if the report uses the same macro name in more than one DEFINE statement. Also, only the first 30 characters of an identifier name are significant. (p.59)
RPT-0010macro call nesting level exceeded
This error will occur if, in a REPORT or EXECUTE statement, the same SQL macro is called recursively.
RPT-0011nested macro definitionRPT-0012*** Ignoring following source lines (up to '..'):
This message has obvious meaning.
RPT-0013variable multiply declared -- this declaration ignored
More than one variable with the same name have been declared in the report. Also, only the first 30 characters of an identifier name are significant. (p.59)
RPT-0014mainline RPT program contains no executable linesRPT-0015*** <x> in illegal positionRPT-0016divide by zero ( <statement> )
精品推荐