Can you run the plsql from the target machine pointing to the source machine. This is how the code is being run, so I'm wondering if it is some strange character being returned that is not recognized. I don't know what it could be, but since the error has to do with an unreconized character or something like that, I wonder if it might have something to do with the different character sets. Just run the command with the dblink after the procedure call.Good point! It produces the same error:
SQL> set serverout on SQL> / declare * ERROR at line 1: ORA-02083: database name has illegal character '-' SQL> list 1 declare 2 v varchar2(1000 char); 3 c varchar2(1000 char); 4 begin 5 DBMS_UTILITY.DB_VERSION@padsol25(v,c); 6 dbms_output.put_line(v); 7 dbms_output.put_line(c); 8* end; SQL>
I am not sure this is your problem but I had once this error when trying to import through database link:ORA-02083: database name has illegal character '-'
In my case it had nothing to do with the hostname of the server or name resolution. It was related to the global_name of the instance.I could query using the link but not perform a remote import.