I have as stored procedure which executes a dynamic SQL at the end. The dynamic SQL inserts into a temporary table declared at the begining of the procedure. When i execute the proc, it executes for a while and then gives me a truncation error.
When i test the code witht out the proc, it works fine and come back with the result set. I am not able to figure out what culd be the issue.
Kindly assist me in this..I have tried setting all colum lenghts to very high values then required but still it does not work when i execute the proc.
View Complete Post