{"action":"opened","issue":{"url":"https://api.github.com/repos/OraOpenSource/Logger/issues/100","labels_url":"https://api.github.com/repos/OraOpenSource/Logger/issues/100/labels{/name}","comments_url":"https://api.github.com/repos/OraOpenSource/Logger/issues/100/comments","events_url":"https://api.github.com/repos/OraOpenSource/Logger/issues/100/events","html_url":"https://github.com/OraOpenSource/Logger/issues/100","id":68872866,"number":100,"title":"dbms_output / timing","user":{"login":"MGralike","id":8393411,"avatar_url":"https://avatars.githubusercontent.com/u/8393411?v=3","gravatar_id":"","url":"https://api.github.com/users/MGralike","html_url":"https://github.com/MGralike","followers_url":"https://api.github.com/users/MGralike/followers","following_url":"https://api.github.com/users/MGralike/following{/other_user}","gists_url":"https://api.github.com/users/MGralike/gists{/gist_id}","starred_url":"https://api.github.com/users/MGralike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MGralike/subscriptions","organizations_url":"https://api.github.com/users/MGralike/orgs","repos_url":"https://api.github.com/users/MGralike/repos","events_url":"https://api.github.com/users/MGralike/events{/privacy}","received_events_url":"https://api.github.com/users/MGralike/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-16T08:31:17Z","updated_at":"2015-04-16T08:31:17Z","closed_at":null,"body":"When using DBMS_OUTPUT please use the following to set the buffer:\r\n\r\nDBMS_OUTPUT.ENABLE (buffer_size => NULL); \r\n\r\nThis to avoid \r\n\r\nORA-06502: PL/SQL: numeric error or error in value : character string buffer too small.\r\n\r\nand/or... get rid of the '>>>' output \"functionality\" in the timing section (aka split functionality from output). When accidentally getting into loops and/or unexpected processing (thus testing with start and stop timing), the following might occur when building up insightful output\r\n\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320077] - 00:00:00.002421\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320078] - 00:00:00.002422\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320079] - 00:00:00.002423\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320080] - 00:00:00.002433\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320081] - 00:00:00.003421\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320082] - 00:00:00.002321\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320083] - 00:00:00.002433\r\n>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  STOP : Backup(commentaar): WGJN.BACKUP[ ID:6320084] - 00:00:00.058320\r\n\r\nI hope you get the idea...it will end up in a buffer too small error.\r\n\r\nThanks\r\n\r\nMarco\r\n\r\n"}}