Questions tagged as 'oracle'

Tagged questions
0
answers

C # Consume Oracle Web Service Return Null

Good I have a quite big problem that has taken me Days of Days and I continue in the investigation I try the WSDL from the SoapUI and everything Marcha to perfection. but when trying to consume from .net C # the query sends the paramete...
asked by 02.03.2017 / 17:27
0
answers

Update with Cursor in Oracle

I have several doubts about the use of cursors in ORACLE especially to update records, in several places I read that the declaration of the cursor is done with the CURSOR parabra in the declare, but in my work they have declared cursors in Store...
asked by 21.02.2017 / 17:59
0
answers

Temporary table SQL SERVER to CURSOR in PL-SQL

Greetings How could you transform the use of a temporary table to make an update in SQL server to an equivalent code in PLSQL with a cursor? ALTER proc [dbo].[sp_lista] (@pcFI datetime, @pcFF datetime, @vSuma tinyint) as beg...
asked by 21.02.2017 / 18:47
1
answer

Continue sequence of database records based on field "order"

I have a question about the database. My problem is that I do not want to be able to add a record with an existing order. Instead I want to make room for the new record and the others increase in one order for it I have a table in which...
asked by 30.01.2017 / 05:16
1
answer

access to .properties file in .war file deployed in weblogic 12c

I have a file .properties in which I send certain parameters so that certain functions are executed in my application. What I would like to know is: Is there any way to access this .properties file, edit it and save it, without having to a...
asked by 02.02.2017 / 14:18
1
answer

Fill dataset with MongoDB and c #

How can I migrate this Oracle code to MongoDB? I'm using C # and the idea is to fill the Dataset with Mongo data.    Original Code private DataSet datos() { DataSet dataSet; OracleCommand oracleCommand = conn.Create...
asked by 24.01.2017 / 01:07
0
answers

Oracle Entity Framework - map tables of different schemes

I have several schemes (ESQ1, ESQ2, ESQ3, etc) and each scheme is for a different context, but there are cases in which I need to access tables of different schemes, and at the time of mapping the tables I can only see the tables of the user wit...
asked by 05.01.2017 / 14:11
0
answers

Move file from local to server by ssh or sftp

I use the spool to capture the result of a simple query and pass it to a TXT that I place on my local machine in C: \ TXT. But I need to deposit that file in a remote directory using ssh. How could it be done? I was researching to see if from...
asked by 11.12.2016 / 00:06
1
answer

Cursor with Update

Greetings from Costa Rica, I'm starting with Oracle PL / SQL (running the systems race) and I want to build a cursor as a practice to update the registry of names, emails, telephones and cards of the entire database. The information of cli...
asked by 09.12.2016 / 00:27
0
answers

Oracle - Entity Framework - Stored Procedures - Cursors

Any ideas to solve the following: Current Scenario. I have stored procedures in Oracle which return the result of a Select in a cursor. This procedure is mapped with EF, which automatically generates a complex class based on the cursor column...
asked by 18.11.2016 / 15:15