Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid format error when using function as parameter input for debugging

WeisDec 20 2022

Hi,
Thanks for creating the debugging feature for the Oracle database in VS Code.
Often my parameter inputs for unit tests are function calls, but these seem to not be accepted at the moment:
vscode_oracle_dev_tools.pngIt seems that for the date the NLS_DATE_FORMAT must be used, otherwise it is rejected. Also for the other data types function calls do not work (and for a varchar2 it does not give an error, but passes the function call itself as a string).
Am I doing something wrong here, or is it just not supported at the moment?
Also: now the input parameters are reset on each subsequent call, it may be convenient to retain them.
Regards

Comments
Post Details
Added on Dec 20 2022
2 comments
1,099 views