Friday, 20 October 2017
Friday, 13 October 2017
SQL> insert into a values(1, 5);
SQL> insert into a values(2, 10);
SQL> insert into a values(3, 15);
SQL> insert into a values(3, 0);
SQL> insert into a values(4, 20);
SQL> insert into a values(5, 25);
SQL> select x, y from a order by x;
v_temp number:= 30;
cursor c_temp is
select x, y from a order by x;
fetch c_temp into v_x, v_y;
exit when c_temp%notfound;
dbms_output.put_line('Total is :'||v_tot);
when others then
dbms_output.put_line('Found Oracle error: '||SQLERRM);
Total is :7
Total is :5
Total is :5
Found Oracle error: ORA-01476: divisor is equal to zero
PL/SQL procedure successfully completed.
Thursday, 12 October 2017
Friday, 6 October 2017
Tuesday, 3 October 2017
Redirecting Talend Console logs to file
Redirecting Talend console logs is required by almost all Talend projects. This is very easy to implement in talend. Use tJava component at the start of any job and enter following lines into it.
Drawback of implementing this strategy is that, it will not print or display anything on the console while using IDE or independent execution. This becomes difficult when developer is developing or debugging the job. Because, it is an extra effort for a developer to open a file every time to find out whether the job is executed successfully and generated error or not.
Monday, 2 October 2017
Thursday, 17 August 2017
Sunday, 30 July 2017
Thursday, 18 May 2017
Wednesday, 17 May 2017
Wednesday, 10 May 2017
[ICMD_10023] Missing required command option: [<-DomainName|-dn>]
<-Options|-o> options, separated by space in the form of name=value. Use single quote to escape any equal sign or space in the value.
Defines a connection and the connection options.
Monday, 8 May 2017
Setting the NLS_LANG environment variable on the client to match that of the Oracle Database (found in v$nls_parameters system view) is NOT NECESSARILY the correct configuration. NLS_LANG is used to tell the Oracle Client what character set the client's (or Informatica Server's) OS is using, so that appropriate code conversion can take place (or be skipped, when code pages match between Oracle client and server). Please see Oracle Technical Note 158577.1 - "NLS_LANG Explained" for a more elaborate explanation as well as troubleshooting tips. Please contact Oracle Support for configuration suggestions, as needed.
The NLS_LANG variable must to be in uppercase on UNIX.
If there is any mistake in the value setting of this variable (such as a spelling mistake), you may encounter the ORA-12705 error.
For a list of valid languages, territories and character sets, the relevant National Language Support Guide for your version should be consulted.
Completely unsetting the NLS_LANG will use the default value AMERICAN_AMERICA.US7ASCII.
This may fix the ORA-12705 error. However it may give unexpected results, as you are only dealing correctly with characters that can be represented completely with 7-bits. When you use a special characters (usually stored using the 8th bit), this will result in conversion problems.
On Windows, if there are several Oracle_HOMEs on the machine, ensure you have set the correct ORACLE_HOME.
Once you have determined the correct ORACLE_HOME , open the registry and verify the NLS_LANG entry in the special path.
On Windows, if you set NLS_LANG as an environment variable, this will take precedence over the value set in the Registry.
In most cases this is not preferable, so you may unset this variable.
On UNIX, depending on the shell, you will have to export the environment variable to make it visible to the sub-processes.
Oracle SQL Developer is the only "known-good" client side tool which can be used to view characters correctly and works independently of client-side NLS_LANG settings.