|
by: kristoff plasun |
last post by:
I have a problem with a C++ DCOM application that
prints Crystal Reports with data from Oracle.
The SQL query is relatively complex but when
the report is printed from the Crystal Reports
designer it shows up very fast. When the report
is printed from my application it takes about
ten times as long to get the report to appear.
When printing straight from the Crystal Reports
|
by: Sezhman |
last post by:
I am using Oracle Database, Can anyone tell me, how to connect to the oracle
database and run the stored procedure in oracle.
I am facing some problem in this. please guide me..
--
Sezhman
|
by: Chan |
last post by:
Hi,
I am trying to send set of rows from my c# web service to Oracle stored
procedure.
I think I can get this done using OpenXML in SQL Server.
How to implement this in Oracle Stored Procedure?
Can I pass a table or cursor or XML to Oracle stored procedure?
|
by: robin via SQLMonster.com |
last post by:
I've tried several different way to execute a oracle stored
procedure from a DTS package but to no avail.
I have a Linked Server setup which does bring back Oracle tables from the
server when I click on the Tables icon.
Here's my DTS statement:
exec omsd..OMS_TECO.SP_Callback_Update_Pkg(116);
omsd is the linked server
|
by: Chan |
last post by:
Hi,
I am trying to send set of rows from my c# web service to Oracle stored
procedure.
I think I can get this done using OpenXML in SQL Server.
How to implement this in Oracle Stored Procedure?
Can I pass a table or cursor or XML to Oracle stored procedure?
|
|
by: Brew |
last post by:
Hello,
I'm writing an ASP.NET 2005 (VB) Website with an Oracle 9i backend
I have an oracle package with stored procedures and functions I need to
use from the
VB Code, I'm trying to use the SQLDataSource to call a stored procedure
passing parameters and then displaying the results on a GridView
control my trouble is with the parameters and displaying results into
the GridView.
|
by: Tom |
last post by:
Looking for some help with stored procedure call issues. Conceptually, I
need to pass a data structure as the sole parameter to the Oracle stored
procedure. Sounds simple enough....but how?
First, looking at this from the stored procedure side, I see a few things
the procedure can do:
1) receive a CLOB/BLOB
2) receive a user defined data type
3) receive multiple params, one for each distinct data element
|
by: shruthimr |
last post by:
Hello,
I have written a java stored procedure to execute an exe file, which works fine when compiled.The class code is given below.
create or replace and resolve java source named "CommandExection"
as
import java.io.*;
import java.util.*;
public class CommandExection1 {
|
by: Gloops |
last post by:
Hello everybody,
Is anyone able to give me some indications about how to develop an
Access interface for an Oracle database ?
I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i 9.2.0.1.0 and
ODBC 3.525.1117.0, on Windows XP Pro 5.1.2600 SP2 Nu 2600.
I failed executing an Oracle stored procedure from Access, and a trigger
to store data to a temporary table was active from SQL*Plus, but
|
by: E11esar |
last post by:
Hi there.
I have written a C# web service that calls an Oracle stored procedure. The SP is a simple select-max query and the table it is getting the value from has about 2.8 million rows in it. The field being MAX'd is an index field in the table. I have further ensured that the table has had an analysis and rebuild run on it to ensure good integrity but still I am finding the stored procedure takes around 3 minutes to return the MAX...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|