[PARSING] plsql varaibles with $ and #

[sosoba]

Describe the bug
Use variable with the characters $ or # a in the name. Example:

select :a$# from dual;

Expected behavior
Pass

Actual behavior
Parse error: Unexpected "$# from du" at line 1 column 12. SQL dialect used: "plsql".

Usage

• How are you calling / using the library? Playground
• What SQL language(s) does this apply to? plsql
• Which SQL Formatter version are you using? 15.4.9

[nene]

Thanks for reporting.

Could you point me to the documentation that describes the syntax of these variables in PL/SQL? I haven't been able to find this info by myself. The best I've managed to find is this page but it doesn't describe the syntax, only the usage.

[sosoba]

I searched for a long time and couldn't find anything better than the chapter 5.3.1 Rules for Placeholder on your site.

[nene]

Yeah, but this section says nothing about $ and # characters.

[sosoba]

Yeah, but this section says nothing about $ and # characters.

You have right.
There is also:
Placeholder-Expressions
Database-Object-Names-and-Qualifiers.
The second says:

Nonquoted identifiers can only contain alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#). Database links can also contain periods (.) and "at" signs (@).

[nene]

Sorry for the delay on this. I don't have means to test this myself with Oracle, so I just take your word for it.

Looks like I had explicitly turned the support of these characters off in parameter names, because the documentation said so.

[nene]

Fixed in 15.4.10