- SQL Problems

You can use "TRACEALL=3" AND "TRACEFILE=8" to get more (non-SQL) file related info, instead of "TRACEALL=9".

For SQL trace, you need TRACESQL=8 to get detailed info (though this produces a very big trace of ALL Oracle calls). TRACESQL=3 will give you SQL errors only.

To locate error messages, try searching for, for example, "SYSTEM E018" (upper case, with two spaces in the middle). This is the key the kernel uses to read the MSF.PRO file to retrieve the error text for error 18. You will need TRACEFILE=8 or greater to see this trace line (it starts "sysfrd:"). To see a list of the system error numbers and the corresponding text messages, run @ERROR and enter function name SYSTEM.

Comment on this topic

Topic ID: 750054