on 10-20-2009 1:25 PM
Hi,
I am accessing a view in DWH system using EXEC ENDEXEC statements and getting the error as mentioned in the subject.
The Oracle error description is
ORA-02019: connection description for remote database not found.
The DB link is given in the format OPS$SMART@VIEW_NAME@dblink.
I think the link name is correct . Is there any other was I can check if the connection is established between the DWH and SAP system?
Any pointers will be appreciated.
Thanks in advance,
Neethu Mohan
Hello Neethu,
just a basic question .. is the database link created and specified correct?
Please post the result of the query:
shell> sqlplus / as sysdba
SQL> select * from all_db_links;
Please also check sapnote #25383 for the ABAP native SQL syntax.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Stefan,
Thanks for your quick response.
How can we check the link is created ? Is there any place where it will be maintained, to confirm whether it is created ?
I got the link from my functional consultant with the statement that it is created.
When the below mentioned query is executed , it gave the error " Period missing for last statement" , So I tried giving it inside EXEC ENDEXEC. Then it again dumped with ORA-00900: invalid SQL statement.
Please correct me if I am wrong anywhere. I do not have much exposure in writing SQL code.
Thanks.
Neethu Mohan
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.