Is there an alternative to DBMS_OUTPUT???
571956Apr 25 2007 — edited Apr 25 2007I have written a stored procedure that builds an update statement dynamically, basically I am updating a table with multiple fields, but not all fields need to be updated.
So I am building my update statement to update only the fields that need to be. BUT, I am still testing it and I want to output the completed Update statement (that is being assigned to a variable, sqlScript) so I can verify that it looks good.
But I am getting an Oracle error (ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line). Obviously the update statement is violating the DBMS_OUTPUT 255 character limit, is there anyway I can avoid this error?? Are there any alternatives to the DBMS_OUTPUT?? Can I output my variable to a .txt file or anything??
Any help would be greatly appreciated!
Thanks.