Em Andamento

Update an Oracle Table from a C# console program

I need a VS 2010 Console Project (Framwork 4) that receives 4 strings as parameters and makes an updates a record on an Oracle table named "sri_transacc_electr" (Oracle Database 11g Release 11.2.0.1.0 ). Below is the SQL create script for this table.

The first string parameter is the key to search the record. Asume the key will always exist on the table.

The other parameters will be the values to be updated.

A sample SQL update will be as follow:

update sri_transacc_electr

set tele_autorizacion = {parameter_2),

tele_ESTADO_SRI = {parameter_3},

tele_MOTIVO_SRI ={parameter_4}

where tele_CLAVE_ACCESO = {parameter_1}

Please let me know if you have questions.

Regards,

Rogelio

SQL Script to create the table

=====================================================

drop table sri_transacc_electr;

create table sri_transacc_electr(

tele_CLAVE_ACCESO varchar2(100),

tele_autorizacion varchar2(100),

tele_fecha_autoriz date,

tele_codigo_empresa number(2),

tele_tipo number(4) ,--([url removed, login to view] , T. Transacc)

tele_codigo number, --

tele_tipo_emision number(1),-- Normal,Indisponiblidad

tele_codigo_sri number,

tele_codigo_indisp_sri varchar2(100),

tele_ambiente number(1),-- Prueba, Produccion

tele_GENERAR_PDF VARCHAR2(1), -- (G=GENERAR; E= ENVIO CLIENTE)

tele_GENERAR_XML VARCHAR2(1), -- (G=GENERAR; E= ENVIO SRI; R= REENVIO SRI)

tele_fecha_Firma date, -- (fecha de firma)

tele_ESTADO_SRI VARCHAR2(1), -- (A=APROBADO; R= RECHAZADO)

tele_coderror_SRI NUMBER(4),

tele_MOTIVO_SRI VARCHAR2(3000) ,

tele_ESTADO VARCHAR2(1), -- (I=INGRESADO; X= ANULADO)

tele_fecha_sistema date, -- (fecha de sistema)

tele_terminal VARCHAR2(30)

)

pctfree 20

pctused 70

storage

(initial 500K

next 500K

maxextents 99999999

pctincrease 0 )

tablespace tbsp_si

/

create public synonym sri_transacc_electr for &usuari..sri_transacc_electr;

drop index sri_trans_elec_pk

/

create unique index sri_trans_elec_pk on

sri_transacc_electr(tele_CLAVE_ACCESO)

pctfree 20

storage

(initial 500K

next 500K

maxextents 999999999

pctincrease 0 )

tablespace tbsp_isi

/

Habilidades: Programação C#, Oracle

Ver mais: string programming, search string, programming strings, oracle sql number, search console, rogelio, console sql, console c, c r, c de, oracle sql database project, create database oracle, oracle project sql, oracle project database, database programming sample, sharp script, project oracle database, create oracle database table, table create script, oracle database 11g, create table script sql, oracle table create script, sql update, oracle create table script, project database oracle

Acerca do Empregador:
( 35 comentários ) GUAYAQUIL, Ecuador

ID do Projeto: #6800419

Premiar a:

customizedata

I have already made a C# program using oracle connector for .net. I have 11g express edition. I am copying the script and making a table and synonym. I will provide console program requiring 4 inputs and data will be i Mais

$50 USD em 1 dia
(58 Avaliações)
6.1

3 freelancers estão ofertando em média $121 para este trabalho

rinsadsl

A proposal has not yet been provided

$157 USD in 3 dias
(12 Comentários)
4.8
omarqandeel

C,C++,C#,Asp.net, Java Programming, also I'm a system administrator with 5 years of experience in system administration and technical support for different platforms, I'm certified from Redhat, Microsoft, Vmware. I hav Mais

$35 USD in 3 dias
(1 Comentário)
1.5
ramaapps

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)
0.0