All Questions
Tagged with oracle sql-server
2,720
questions
1
vote
1
answer
50
views
Ordinal enum mapping with Hibernate 6.5
I'm upgrading Hibernate from 6.1.7 to 6.5.2, there are many enum columns in my entities marked with
@Enumerated(EnumType.ORDINAL). My codebase has to run against both Oracle and SQL Server.
The ...
0
votes
1
answer
60
views
Call a function in SQL Server and Oracle with same syntax
To call a function, SQL Server uses the following syntax:
SELECT dbo.GetSquare(Item) AS SquareValue
FROM Squares;
In Oracle the same can be achieved with:
SELECT GetSquare(Item) AS SquareValue
FROM ...
0
votes
0
answers
41
views
Powershell as Visual Studio task "Exception calling "Fill" with "1" argument(s): "Exception of type 'System.OutOfMemoryException' was thrown.""
I'm trying to get a hang of using Powershell and use it to automate ETLs through VS. Currently I'm working on moving data from Oracle into SQL server using Powershell and launching it using an Execute ...
1
vote
1
answer
110
views
Select a constant value using same SQL statement in SQL Server and Oracle
I need to write a query which will be run against SQL Server and Oracle. A query just selects a constant.
In SQL Server, I can do this:
SELECT 1 AS Value;
And in Oracle:
SELECT 1 AS Value FROM DUAL;
...
0
votes
1
answer
75
views
Same insert statement on linked server, different behaviours
I have an insert statement basically something like this:
insert into openquery(Test_LinkedServer,
'select a,b,c from my_ora_table')
select a, b, c
from my_dbo_table;
...
0
votes
0
answers
70
views
Powershell Oracle to SQL. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding
I'm trying to find a way to import data from Oracle to a SQL Server using PowerShell. I used the script below to import it and it works perfectly when the result is small.
add-type -path 'C:\Oracle\...
0
votes
1
answer
98
views
SSIS package with Oracle connections fails running from SQL Job but works from Integration Server
I have developed a SSIS package that uses an Oracle connection.
It works if I run from Visual Studio 2022 and also if I execute the package in the Integration Services Server (Both options at SQL ...
0
votes
1
answer
79
views
How do I solve a "linked-server error" when using execute(@sql) at [linked_server] when the server is already registered?
I have a requirement to link to an Oracle server in the cloud through a linked server in Sql Server.
I have created a stored procedure to execute a generic PL/SQL script that returns an IEnumerable<...
1
vote
1
answer
185
views
How can I directly connect to SQL Server or Oracle using TMS WEB Core in Delphi?
As per the TMS WEB Core documentation, it seems like the primary way to access a database is through the corresponding REST API (XData) or Embarcadero's RAD Server. However, I find this approach ...
0
votes
2
answers
102
views
Is there a way to write joining where clauses without AND operator?
Just for curiosity, is there a short/pretty way to write classic SQL where clauses without the AND operator for joining tables?
Classic:
select *
from table1, table2, table3
where table1.fkId = ...
0
votes
0
answers
113
views
ORA-28500 from dblink oracle UUID
I get an error when I call select from dblink SQL Server to Oracle
SELECT UUID FROM TABLE@MSSQL_DBLINK;
[Error] Execution (1: 1):
ORA-28500: connection from ORACLE to a non-Oracle system returned ...
-2
votes
1
answer
73
views
C# ODBC get value of declared variable after query has executed
Trying to see if there's a method by which I could get the value of object_name from the following query. Printing the variable name doesn't output anything. I've tried odbcdatareader and execute....
0
votes
1
answer
56
views
How to call oracle function with no parameter from SQL Server
I need to call an Oracle function Function PK_DM_API_EDIT_ENTITY.DONE from SQL Server.
I call it like this in Oracle:
begin
PK_DM_API_EDIT_ENTITY.CHANGE ('dep', '322');
PK_DM_API_EDIT_ENTITY....
0
votes
1
answer
108
views
Query filter (ArcGIS Pro) on SQL server
At the moment i'm trying to upgrade our old query filter on an oracle database to a SQL server. The old query is as follows:
select * from table.a a, table.b b WHERE sdo_relate(a.shape, b.shape, 'mask=...
0
votes
0
answers
83
views
SSIS OLE DB Command Transformation (Oracle Connection Manager) failing for columns with NUMERIC(28,10) data type?
I am having a lot of trouble getting a new SSIS package to work. Overall, it takes an Excel spreadsheet of data (headers, a few rows, maybe 15 columns) and should upload that data into an Oracle DB.
...