Database links....

[bmycroft]

When I run the attached code I get

"
CREATE OR REPLACE package body load_test as
*
ERROR at line 1:
ORA-02083: database name has illegal character '-'
"

The link 'sponge' is a public database link connecting as user sponge to database with tnsname of sponge. There is no underscore. What the hell is happening!!! To top it off, I can select directly from the link with no problems. Anybody got any ideas?


CREATE OR REPLACE package load_test as
a_var number(10);
END;
/
CREATE OR REPLACE package body load_test as
PROCEDURE demo IS
cursor c1 is
select 'fek'
FROM dual@sponge;
BEGIN
null;
END;

END;
/

-Bob

[jdorlon]

I think Oracle is complaining about your database link, not the package.

[jdorlon]

Ooops, I see you can select from the link directly.

OK, how about this - are you granted any privileges through roles or are they granted directly to your user id?

If they are through roles, grant them direct to the user. Privs granted through roles are not visible from packages, procedures, etc... (Don't ask my why!)

-John

[hbk_emp]

by doing that is one work around but where is '-' related in the code ,check the name for db link in dba_db_links table