Showing posts from September, 2013

PL/SQL Working with Database Objects

create or replace
type obj_xyz_table is
       object (
                id                number       ,
                name               varchar2(50) ,
                surname            varchar2(50)
                -- here can come more properties according to the needs of your project


create or replace
type tab_xyz_table_name is table of obj_xyz_table;

How to specify proxy credentials in web.config

If you need to configure a website to access a webservice etc. which is deployed on another machine vie a proxy, you just need to update your web projects web.config file as shown below:

<configuration>   ...   <!--<>     <defaultProxy useDefaultCredentials="true">       <proxy proxyaddress="http://proxyIPAdress:portNumber" usesystemdefault="True"/>     </defaultProxy>   </>-->   ...
That's all.  Happy coding :)

Creating Setup Files with InstallShield Limited Edition for Visual Studio 2012

This is a nice article that explains how to create a basic setup file using Installshield Limited in Visual Studio 2012 Professional.

PL/SQL Select Next Value of a Sequence

v_counter number:=0;
  select seq_table_id.nextval
  into v_counter
  from dual;