Integrating to the max...BizTalk Style

  There are probably already lot of posts on the installation of the Oracle client, so this is a small note; Error: If you start visual studio on a machine that hasn’t got the Oracle 32-bit client installed, prepare to face the following error; ‘The following assemblies are installed SDK assemblies but could not be shown in the customize toolkit dialog because they…..’ Solution This is because VS.Net is 32 bit and you only installed the 64-bit Oracle client. Install for your DEVELOPMENT environment both the 32-bit and 64-bit client.   HTH, Sander

  The installer starts with the most ‘obvious’ check ever, we need at least 256 colors…can’t even remember a videogame in the Dos Era that did that…. Then the PATH variable is too long… I guess there is some room for minor improvements…   Please consider that I’m just posting this to free my mind and allowing it to relax. Cheers….now it’s time to use the time machine to go back in time and finish the installation….with great joy. Sander

Below is a collection of snippets i've used during a project implementation. If you're working with Oracle, you might be able to gain some quick insight how you can use it for the benefit of your project. Grant / permissions GRANT ALL ON TO ; PL/SQL Cursors CURSOR c_orderlines IS SELECT order_pk FROM orders; BEGIN -- !!turn off the notifications!! v_process := 1; v_id := 0; DBMS_OUTPUT.put_line('Started @' || sysdate); OPEN c_orderlines; FETCH c_orderlines INTO v_id; WHILE c_orderlines%found LOOP FETCH c_orderlines INTO v_id; END LOOP; CLOSE c_orderlines; END; System tables all_tab_columns This is like the syscolumns/systables in SQL Server all_source This allow searches in all entities that exist Inline SQL DECLARE ..... BEGIN END; Retrieve the name of the package $$PLSQL_UNIT Output DBMS_OUTPUT.put_line Queries Top selection: where rownum http://www.oracle.com/technology/oramag/oracle/06-sep/...