Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl and dollar sign on DB objects

guilhermegrgOct 29 2021

Hi all

Trying to use SQLcl here and it hangs on doing a
lb genschema -split
Upon CTRL+C it shows "illegal group reference."

It seems it doesn't like our packages or triggers with the dollar sign '$', as if I try to do a simple describe :

SQL> DESCRIBE AG$SOMETHING_SOMETHING

It outputs:

"Illegal group reference."

This works fine for other objects with simpler names, without the dollar sign.

So this is related to regex it seems.

Is there any way around this, or it simply is impossible to work with dollar sings in db objects with SQLcl?

Thanks for your time and attention!

Comments
Post Details
Added on Oct 29 2021
1 comment
154 views