Re: DBMS_SQL question

Your problem is NOT with Powerbuilder. It is with the method Oracle is using with their DBMS_OUTPUT and, evidently, DBMS_SQL packages.

I have encountered the same errors while using DBMS_OUTPUT.Put_Line. Actually, I am surprised that you're getting around the error by disabling/re-enabling DBMS_OUTPUT.  

I know that the documentation says that this clears the buffers, but in my testing it was not successful. In fact, that was the determination that an Oracle instructor and I came to when I was in a recent class in Redwood Shores, CA.

Please keep me posted on your progress, as I am interested in the results.

Robert R. DeGarmo      St. Louis, Missouri USA
rrdega_at_mo.net              http://mo.net/~rrdega/


-------------------------------------------------