When I double click a procedure or function to see the error ‘An error occurred while fetching data’ appears.
Here the full trace of problem output window:
{
"resource": "/DATABASE_CONNECTION/object/FUNCTION/FUNCTION_NAME.pls",
"owner": "sqldevclient<->(dbtoolsserver: internal)",
"severity": 8,
"message": "Syntax Error at line 1, column 2\n\nAn error occurred while fetching data\n ^^^ \nExpected: paren_expr_list,'.',AND_OR,partition_extension_clause,\n",
"source": "dbtools",
"startLineNumber": 1,
"startColumn": 3,
"endLineNumber": 1,
"endColumn": 6,
"relatedInformation": [
{
"startLineNumber": 1,
"startColumn": 3,
"endLineNumber": 1,
"endColumn": 6,
"message": "Syntax Error at line 1, column 2\n\nAn error occurred while fetching data\n ^^^ \nExpected: paren_expr_list,'.',AND_OR,partition_extension_clause,\n",
"resource": "/DATABASE_CONNECTION/object/FUNCTION/FUNCTION_NAME.pls"
}
],
"modelVersionId": 2,
"origin": "extHost1"
}]
If I open the same object using classic desktop SQL Developer or Toad it opens OK.
I tried reinstalling the extension, cleaning all extension folders in user Windows profile, etc. Nothing works.