• Calling an Oracle stored procedure from SQL Server

    Is it possible to call an Oracle stored procedure from SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Solve TNS-12502 error

    How to solve TNS-12502 error?

    MITI5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE352,565 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • What is the Oracle Application Object Library?

    What is object library in an Oracle application?

    Nomanjahangirbutt5 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to config report server to run report by Oracle developer 9i?

    How do I configure an Oracle report server so that it runs a report by Oracle Developer 9i?

    Rkon725 pointsBadges:
  • How to export the excel file in oracle

    how to export the excel file in oracle

    Jsr5 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Generate an Oracle query

    How to I generate a query that would display the various job_ids, the sum of salaries, average salaries, minimum salary, maximum salary and the number of people in each job_id?

    berknernice27135 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • Running Oracle reports 10g as pdf from a form

    I have a report which consists of 2 pages to be printed on pre-printed stationery. When I run the report straight from the report builder,it prints perfectly. But when I print it as pdf from a form(button), the 2page report shows as 248 pages and pages keep getting ejected unless I specify each...

    GOWRI5 pointsBadges:
  • How I will find the duplicate rows count from employee table in Oracle 9i

    How can I find the duplicate rows count from employee table in Oracle 9i?

    gettosrinivas35 pointsBadges:
  • How to call trigger stored in database using Oracle Forms

    how to call trigger stored in database using oracle forms

    RoseForHeba5 pointsBadges:
  • How to find duplicate records in an Oracle table

    How do I find duplicate records in a table?

    gettosrinivas35 pointsBadges:
  • Call Oracle Store Procedure from Reporting services

    Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )

    PramodSR35 pointsBadges:
  • Calling an Oracle stored procedure in Java

    In my Oracle database, I have this stored procedure: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Here's what the IDS_TABLE means: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) Would it be possible for...

    ITKE352,565 pointsBadges:
  • What’s the easiest way to test an Oracle stored procedure?

    We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...

    ITKE352,565 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following