We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can't seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are...

Using a linked server I can't seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider "MSDAORA" for linked server "PASSRPT" returned message "Syntax error in {resultset...} ODBC...

We have a situation where we would like to establish a common operational chart for all countries. However, each country, and even each product line within a country, may have its own statutory chart. Can we map multiple statutory charts (and even multiple accounts within each chart) to a single...

We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

I have ThomsonTechnology Textbook Oracle 10g Database Administrator Implementation and Administration IBSN:-13 978-1-4188-3665-8. Oracle OTN website will not log on my Vista machine. I have been able to download Oracle 11g sucessfully.

OracleOraHome92HTTPServer suddenly is not starting anymore, it is giving the below message: "Could not start the OracleOraHome92HTTPServer service on Local Computer. The service did not return an error. this could be an internal windows error or an internal service error. if the problem persists,...

Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

I am using Oracle 8.1.5 with MS Dot NET 2005 on Windows XP with service pack 2. When I am sending data through a stored procedure, it is giving the error of "TNS:12571 : packet write failure" but it’s adding record in table, but truncated data in some columns and no data in the rest of the...

While installing oracle 11g client version of 11.1.0.6.0, I am unable to proceed. In "Oracle Universal Installer Window", the status of installation is stuck at 33% for many hours, it is not proceeding. Please Help

I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I .

i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy