Parser error pop-up - how to capture in clipboard?

Toad for Oracle & DevOps Toolkit
1

Toad for Oracle (64-bit) version 25.1.20.5192

Got a nuisance ORA-SQL-PLSQL pop-up parser error on an insert statement, but the statement was ok and ran successfully.

The column that is flagged contains the following code:

                      , json_query(json_mergepatch(d.configuration_json
                                                  , '{"errorRules":[{"messagePrefix":"Application provided invalid, non monotonically increasing dts to muxer in stream","errorCountThreshold":3}]}')
                                  , '$' returning clob pretty)
                      , 'A'

The last line containing , 'A' represents the next column in the insert statement and the comma in that line is the location of the error.

Would like to report the entire error message, but can't seem to capture it in the clipboard, despite the message telling you exactly how to do it. :slight_smile:

"You may want to COPY this info (Ctrl-C) and then PASTE into your report", but Ctrl-C isn't working.

Regards,
Doug

2

Can you post a screenshot? I am not sure which dialog you're referring to and it could be coming from Toad or from the Parser DLL.

3

image
image2044×287 53.8 KB

4

Well.... that's a new one. :rofl:

I have no idea, but I'll ask someone who does.

Thanks,
Michael

5

Hello Doug,

The next drop of the parser (QP5.DLL) will contain correct parsing of all JSON functions up to the current 23ai Oracle version. Today this is not the case, unfortunately.
The rather long message reports some ambiguity in the syntax - what parser wrongly thinks for now - however shown without newlines which makes it a bit cryptic. Of course that will go away.

The work on the JSON is currently in QA, so you may expect a better parser soon.

Thanks,
Andre

1 Like
6

That is good news. Thanks for the detailed explanation.