I find debugging stored procedures heavy... Sometimes I receive error message "error in asigment" without any information which assigment was bad. Sometimes I receive NO ERROR MESSAGE and my procedure finishes.
How do you debug procedures? Is the 'print' and marking as comment the only way?
The same problem exists when pasting procedure's code into PCC. Error such as "general error" is not descriptive.
How do you debug procedures? Is the 'print' and marking as comment the only way?
The same problem exists when pasting procedure's code into PCC. Error such as "general error" is not descriptive.