SQL Developer

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!

PLS-00352: Unable to access another database

user545194Sep 26 2017 — edited Sep 27 2017

Hi,

Oracle 12cR2

SQL Developer, version 17.2.0

No linked database involved.

PLS-00352: Unable to access another database 'AOL.NET'

ORA-06550: line 57, column 24:

PLS-00201: identifier 'G@AOL.NET' must be declared

This message is returned after entering an email address; i.e. first_name.last_name@provider.com as a VARCHAR2 parameter in a function, because the PL/SQL interface in SQL Developer

does not add single quotes around the string. You can see the envelope icon outside the quotes.

Maybe a bug in this SQL Developer version?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2017

Added on Sep 26 2017

#sql-developer

5 comments

8,767 views