Write for Us
Error Message:Msg 7133, Level 16, State 1, Line 5NULL textptr (text, ntext, or image pointer) passed to %ls function.
Severity level:16.
Description:This error message appears when you try to pass a NULL pointer to the READTEXT or WRITETEXT function.
Consequences:The T-SQL statement can be parsed, but causes the error at runtime.
Resolution:Errors of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. The pointer must have a valid value.
Versions:All versions of SQL Server.
Example(s):USE pubsDECLARE @textpointer VARBINARY(16)SELECT TEXTPTR(pr_info) FROM pub_infoREADTEXT pub_info.pr_info @textpointer 1 25
Remarks:In the above example we try to pass the variable @textpointer to the READTEXT function. Because the variable has only been declared but no value assigned to it, it contains a NULL and the error is raised.