Posts

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>   ...   <!--<system.net>     <defaultProxy useDefaultCredentials="true">       <proxy proxyaddress="http://proxyIPAdress:portNumber" usesystemdefault="True"/>     </defaultProxy>   </system.net>-->   ...
</configuration>
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.
http://jasonklee.com/2013/07/installshield-limited-in-visual-studio-2012-professional/

PL/SQL Select Next Value of a Sequence

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

  dbms_output.put_line(v_counter);
end;