I cannot debug any trigger.I get an Access Violation when the Set Parameter window opens up. I click OK to the error and I am allowed to set my parameters .
ClickingOK tocontinue to debuggenerates the following message:
ORA-06550: line 4, column 185:
PL/SQL : ORA-00936: missing expression
ORA-06550 : line 4, column 3:
PL/SQL : SQL Statement ignored
In the set parameters window and the list of variables,not all columns from the table are listed.
In addition, Toad will stop at a timestamp column (i.e., sys_cre_ts TIMESTAMP (6) NOT NULL).
The Set Parameter window does not pick up the columns type, only thecolumn name.
Issue related to the timestamp datatype as an IN parameter.
If the timestamp parameter is removed there should be no problems with the Set Parameter window or debugging.
In version 9.5, if the input parameters that are non-Timestamp datat ype are filled with values in the Parameters window, the above errors do not occur.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center