-
I've got a problem creating a Linked Server to Oracle in SQL Server. When I use Microsoft drivers (MSDAORA), I receive an Microsoft SQL Server Error: 7303. With Oracle drivers I can create the Linked Server, but when I try to browse the server, or run a query, I receive the Microsoft SQL Server Error...
-
Hello, for my application written in VWD based on a SQL Server Express database i need to get some data from corporate Oracle server (with a complex sql query) to use in different datagrids and internal queries. I need to refersh that oracle data every night. As for (after some research) I suppose, I...
-
John this is exactly what I'm trying to accomplish. The following is pseudocode for my Oracle Stored Proc. CREATE PROCEDURE SelectFromList (
delimitedList varchar2(100); -- --- or type TableValues of number; AS
BEGIN Select * From MyTable Where StoreId in (5,6,7,8) ; OR Select * From MyTable where...
Posted to
Oracle
(Forum)
by
row118
on
05-19-2009, 12:00 AM
Filed under: Oracle, odp.net, delimited list, command types
-
Hi Friends, I have a store procedure, where it returns a result set. The result set has one column - which has another cursor of that particular record. For example: Consider I have a store procedure - it returns employee records. One of the column in the record is a cursor (as like we have employee...
-
Hi Everyone, I know this might not be a ODP.NET
issue but I am wondering whether someone has ever had similar problem before
and can let me know whether the problem is. I have a ASP.NET web application
installed in IIS. And it connects to Oracle database. The application can
connect to Oracle database...
-
May be you should use SQL Server Integration Services. Set up a data flow task, get data from Oracle and push it to a SQL Server table. You may not even need to write code, but there may be some data conversions needed which can also be configured in SSIS. If you are not proficient in the use of SSIS...
-
Hi All, I want to use the new MVC for the new application I am working on. I wanted to know can the database be Oracle? The sample and tutorials are using EntityFramework. Is that supported? Is IIS 6.0 supported for MVC? As per the documentation I need to do some changes to use the MVC. Does anyone have...
-
Hi There, I am using Oracle as database, and on the local report i want to display company logo from external source (i.e. from the same server the application is resids). I am unable to that I googled it but nothing acceptable fining. can anyone help out it. Thanks in Advance.
-
I banged my head enough and actually came up with a solution this this. It's kind of goofy but it's the only thing that I can find that works: 1) You need to stop using the dynamically generated script files (ScriptResource.axd) and instead, reference the static .js files for both "System...
-
Is it possible to map a Oracle Ref Cursor (output param) to an Entity? Take this simple example: Let's say I have an entity called Customer with id (key), name , address. I have a stored procedure called get_all_customers. PROCEDURE get_all_customers( p_cursor OUT t_cursor
) IS
BEGIN OPEN p_cursor...