python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - oracle

SSIS Execute SQL Task continue execution after completion of Oracle stored procedure

I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and every step completion we are logging it in...
test-img

PK1128

sql-server

oracle

stored-procedures

ssis

Votes: 0

Answers: 1

Latest Answer

You can Debug your SSIS Package in Visual Studio to see what's going on. You will need "SQL Server Integration Services Project" software for this. You can install it from VS MarketPlace OR ...
test-img

Gaurav Shah

Update only values in a field in a table where criteria is from a linked table

This is the code I am trying to run, which hopefully makes sense UPDATE OPMAT a INNER JOIN ARINVT b ON a.ARINVT_ID = b.ID SET a.EXCLUDE_REJECTS_BACKFLUSH = 'Y' WHERE b.CLASS = 'PK' In English ...Upd...
test-img

Rob

oracle

sql-update

Votes: 0

Answers: 0

update a record from a table with another table's data then return the result

As I said in the title, I need to "update a record from a table with another table's data then return the result". I want change multiple rows and I already accomplished that with this query...
test-img

murilo tegani

sql

oracle

plsql

Votes: 0

Answers: 2

Latest Answer

Works for me, after removing the 'into info' from the subquery: create table demo (id, val) as select rownum, column_value from sys.ora_mining_varchar2_nt('Red','Yellow','Orange','Blue'); select *...
test-img

William Robertson

How do I correctly input Date in Oracle SQL

I created a table with parameters: GUIDE_NUM NOT NULL CHAR(4) LAST_NAME CHAR(15) FIRST_NAME CHAR(15) ADDRESS CHAR(25) CITY CHAR(25) STATE ...
test-img

Anthony Alvarez

sql

oracle

ora-01843

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs