• 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...

    ITKE413,660 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...

    ITKE413,660 pointsBadges:
  • Oracle licensing: I need the documents related with the file F0092

    Needs to identify named users in JDE World and One World to ensure compliance with Oracle Licenses. A user may have multiple profiles in multiple environments which in Oracle's eyes would be counted as one named user We are looking at using the following fields to capture a unique identifier that...

    Bhuvanendar5 pointsBadges:
  • COMMUNITY ANNOUNCEMENT: Tell us your Data Center Tales and you could win a Nintendo Wii

    Tell us your Data Center Tales and you could win a Nintendo Wii We want to hear your stories or see pictures of your craziest data centers. Your contest submissions will be published on the Tales from the Data Center blog for all to read. This two-month long contest (Oct-Nov) is your chance to win...

    ITKE413,660 pointsBadges:
  • Oracle RR Date Format

    Can anyone tell me about RR Date format in Oracle 9i (SQL)?

    JOGENDER20095 pointsBadges:
  • A framework compatible with Oracle 10g

    Please I need a .NET framewoork compatible with Oracle 10g.

    Tchywallace220 pointsBadges:
  • Compare values in same column in Oracle PL/SQL

    I have a set of data in table. For example, let my data be: id         col1 ------------- 1          a 2           b 3           c 4            d 5           a 6            b 7            e 8            f...

    usoracle5 pointsBadges:
  • Build relationship between two tables from different Oracle databases

    Can I build a relationship between two tables from different Oracle databases?

    hahamama5 pointsBadges:
  • ORA-01000: maximum open cursors exceeded

    I'm getting the ORA-01000: maximum open cursors exceeded in one XML. How do I resolve this? All result set and statements are closed in finally block.

    Nikhitasuresh5 pointsBadges:
  • Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to Oracle side, so I know the concept of SQL and PL/SQL. Relating to this I dont have a project of this. So please give me some titles of project at least I can go through this. Regards.

    Ingalagi5 pointsBadges:
  • I would like to install Oracle database on OS X MacBook

    I have looked in the Oracle Technet site for a version of Oracle suitable for OS X.  I downloaded Oracle 10.2.0.4.0 because it said that it was compatible with Mac OS X. However, when I attempted to install the application, nothing happened. Upon closer look, the documentation seem to point to Max...

    JavierS45 pointsBadges:
  • Integration of Oracle Reports with Oracle Forms

    How do I integrate Oracle Reports in Developer Suite 10g with Oracle Forms?

    AMJAD5 pointsBadges:
  • View .pdf file from Oracle Forms 10g

    Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...

    NasoTang5 pointsBadges:
  • Create an Oracle database

    How do I create an Oracle database?

    PSS10 pointsBadges:
  • Is it possible to run a query on two tables in two physical databases using MySQL?

    I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

    ITKE413,660 pointsBadges:
  • Export data from Forms to Excel

    How to export the selected data from Forms to Excel?

    Brithivi5 pointsBadges:
  • Connecting D2K 6i with Oracle database 11g

    I'm having a problem connecting D2K 6i with Oracle database 11g. What should I do?

    manishbarbate10 pointsBadges:
  • Importing dmp file

    What is the procedure for importing a dmp file?

    PSS10 pointsBadges:
  • 64-bit client to 32-bit database

    I have a 64-bit client that is trying to connect to my oracle database which is a 32 bit machine. Is this possible? They have tried to use the 32-bit client software on the 64-bit machine. Is this the problem? Is there 62client software for Oracle 9i? Really need your help on this one. Thanks!

    Rwbaker15 pointsBadges:
  • Oracle: Can a character set be changed after a schema has been created?

    My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...

    DeloeranGuy55 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.

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

Following