I'd like to know what are the mandatory steps in order to connect to an Oracle DB which is stored on a Unix server from a PC on Windows XP.
We currently have ordered the module SAS Access-To-Oracle for every computer which will need to run the application and it should be installed soon.
I've already read a lot of documentation about the Syntax to use in order to connect to an oracle DB and to execute SQL statements (using pass-through facility or not). This is not difficult to understand and it's not my main concern about it.
In fact, I just wonder if we need to install an Oracle component on the clients (Listeners or something else) or if everything will be managed by the SAS module.
e.g.: What should be the value of the parameter "path" in the following statement in order to access our distant DB ?
If you are using the BI Platform, then the connection to Oracle information, such as path and password, etc, can also be defined in the metadata. You might wish to look at the data management documentation for the Platform, in that case.
We successfully installed the SAS access to Oracle module and succesfully connect to the Oracle database.
Now we have isssues with the execution of a procedure which is stored on Oracle.
Here is the part of the log describing it: 53302 execute(exec p_write_data) by oracle;
ERROR: ORACLE execute error: ORA-06550: line 1, column 8: PLS-00201: identifier 'P_WRITE_DATA' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored.
Would you have any idea why we get this message ? Is it possible to retrieve the available procedures/functions' names stored on the Oracle side ?
If a SAS data set contains variable names that are Oracle reserved words, the above error will be returned and The variables will need to be renamed, using names that are not Oracle reserved words.