exnirad@brolga.cc.uq.oz.au (Nirad Sharma) (10/14/90)
I am going to write a PRO*C programme which creates SQL queries based on tables passed by the user. Some of these queries could grow quite large including the "select X, Y, Z" part. What is the limit to the size of a query in PRO*C? I have checked my manuals but cannot seem to find it. I am referring to the length of the TEXT describing the query, not the size of the query result. Assuming some limit, what are some ways of getting around it ? Off hand the application of views come to mind but the continuous creation / deletion of these views could be quite messy. (Has anyone got any idea how good Oracle's query optimiser is at handling joins of several views coupled with even more conditions?) I am using Oracle RDBMS V5, PRO*C V1.1. Any help much appreciated. Nirad Sharma (exnirad@brolga.cc.uq.oz.au) Continuing Education Unit The University of Queensland AUSTRALIA