In this blog post, you’ll learn more about the Sybase Error Plan not available. and the reason for receiving this error
Sybase SQL Error Message
Plan not available.
Reason for this Error
“User request for the plan and there is no plan in the cache to be returned. cases when this error will be returned :1. User makes a connection and executes select graphical_plan() or select html_plan(). 2. When the the SQL function graphical_plan and html_plan is used to get the plan for an IQ query for which IQ does not generate plan. “