when we execute the first main procedure and it calls the second procedure (both defined with optional debug, we can get them to work. The minute we try to run them under DEBUG, then when the second SP is called, it gets thousands of -805s. procedure works just fine with execution w/o debug turned on but fails when run debug with -805. And if disable call to this SP and try another, same error works.
we have other SPs that call other sps where we don't get the -805s when we enable debug mode and enter DS debug..
How do i get rid of the -805s if debug mode is enable and operational? With it just enabled but NOT IN Data STUDIO Debug mode, it works fine. I've even bound the sps before entering debug mode. But still get -805s. Literally thousands.
And everything is NATIVE mode SPs.
Second question: These SPs all had a owner of XYZ which was also the owner/creator of the tables. But when anyone executes the SP, they get a -551 on access to a XYZ.tbname. Should XYZ have full access to XYZ tables. or am i missing something here.
Thanks Myron W. Miller