Home >
database > Oracle custom data type value in the process of debugging code to check the problem.
Oracle custom data type value in the process of debugging code to check the problem.
Your brother have a oracle to debug the question for you, when I was in the adjustment of the oracle stored procedure code will encounter type custom data types of data types, but sometimes I want to see directly inside the data type of value, is there any way to see? Such as a. col1 I want to know his worth, I know now that one way is to put it to a variable, such as v_a=a.c ol1 so I monitor v_a can know the value, but because of our process were written a long time ago, when they are writing at the time of judgment processing is directly with a.c ol1 this form directly to judgment, not to copy a variables through the first judgement, I tried directly in toad monitoring a.c ol1 found not its value, do you have any brother, give a way to directly see the value, and I don't know if my monitor value when the custom data types to write the wrong grammar,