Tag Info

New answers tagged

0

And sometimes following Oracle documentation solves quite some hassle. Make sure Basic Instant Client is deployed before running the ODBC install script. Unzip the ODBC Instant Client package, then execute the odbc_update_ini.sh script with Driver Manager installed directory as a command line argument. (For complete syntax, please run "odbc_update_ini.sh" ...


2

Table person is situated in schema assigned to your apex workspace. You can go to APEX IDE to the section SQL Workshop -> Object Browser, schema name will be displayed in the top right part of the page. Or you can execute query: select owner from all_tables where table_name = 'PERSON'; You will get names of all users that have table with such name. After ...


0

I just deployed Instant Client in a directory and after updating LD_LIBRARY_PATH (including the lib directory of Instant Client) and ORACLE_HOME I was facing the same issue. I now have updated PATH (including the bin directory for Instant Client) and this solved the problem.


0

On Unix/Linux system you can use the user level configuration files to override system level entries. System-Level User-Level Configuration File Configuration File ------------------ ------------------- sqlnet.ora $HOME/.sqlnet.ora tnsnames.ora $HOME/.tnsnames.ora The system-level configuration Files can be found in the ...


0

Rename (archive) the table. If wanted, remove all records of that table by means of a DELETE command. Then you control when you really lose the data, by means of doing the commit on that DELETE command.


0

You can actually start that service, while you are waiting on it to start in another session. Even if both starts occur at the same time, Windows should be able to handle that correctly, and end with the service being up. Or, you sleep. What time ? Put something, and test. Ain't that hard, no ?


0

May be due to invisible characters, which could come from a wrong FTP copy. Maybe because you don't have a newline after the last slash ? Try removing empty lines inside the complete PL/SQL block.


0

1) If you want the headings in one line, you have to use a UNION with a select from dual. Example: select '"'||'col1'||'","'||'"col2"'||'","'||'"col3"' from dual union select '"'||col1||'","'||col2||'","'||col3||'"' from table; 2) This one is tricky. It helps to know what ascii character your line breaks actually are. Depending on how they were ...



Top 50 recent answers are included