Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Oct 29 2021
1 comment
149 views