• Do you have an IT blog or website and want to earn 100 knowledge points?

    We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That's why we're asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is...

    ITKE350,300 pointsBadges:
  • Where to download Oracle 11g Express Edition for Windows 64-bit

    When I registered on Oracle's website to download Oracle 11g Express edition database, it only gave me links to only download Windows 32-bit and Linux 64-bit. Is there somewhere where I can download a 64-bit Windows version? Or is it just that 64-bit versions are available for paid Oracle DBs?

    ITKE350,300 pointsBadges:
  • Getting ORA-06508 error message: PL/SQL: could not find program unit being called

    I'm currently using Oracle 10g and Toad 11.5. I'm trying to call an API from an anonymous block. So when I recompile the API after adding "DBMS_output.put_line" and then execute the block, I keep getting this error: "ORA-06508: PL/SQL: could not find program unit being called". But when I end the...

    ITKE350,300 pointsBadges:
  • I found FRM-92101 in oracle application server.

    We are having 10 as middle tier, whenever we open the form always found the error FRM-92101

    Bakre5 pointsBadges:
  • Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2

    Hello, what are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). Will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

    Donpatrona5 pointsBadges:
  • A problem in calling Oracle report by using WEB.Show_Document

    - The application is developed in Developer 10g - The application is` running with non ssomode. (ssomode=false) - When I call a report through form by using: WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||...

    K197070 pointsBadges:
  • Code to retrieve data in Oracle 10g

    I'm new in Oracle Forms and I want to enter the industry number and when I press the retrieve button, name and surname must display. Can you help?

    Otsile5 pointsBadges:
  • How to represent IPv4 and IPv6 addresses in Oracle

    I'm using Oracle and I'm wondering what are the appropriate data types for representing network addresses (particularly in IPv4 and IPv6). Here's a little more information. I'm converting a table that's recording network activity, which was built by PostgreSQL "inet data type" to hold both IPv4 and...

    ITKE350,300 pointsBadges:
  • Equivalent of CONNECT BY clause in SQL Server

    Does anyone know if there's a equivalent clause to CONNECT BY of Oracle in SQL Server? My co-worker told me to use a recursive CTE. Would that work? Thanks!

    ITKE350,300 pointsBadges:
  • Getting ORA-01008 error message: Not all variables bound

    I've only used Oracle several times but I'm having trouble understanding why I'm getting this error. I've been using Oracle's ODT.NET with C# with the following code in a query's WHERE clause. WHERE table.Variable1 = :VarA AND (:VarB IS NULL OR table.Variable2 LIKE '%' || :VarB || '%') AND (:VarC...

    ITKE350,300 pointsBadges:
  • How to use LINQ against an Oracle database

    Right now, I'm able to connect with DataContext to my Oracle database. But I keep getting errors when I'm running the query against the database. I've already looked at the SQL generated and it's for MSSQL and not Oracle PSQL. Would anyone have a way to use LINQ against the Oracle database?

    ITKE350,300 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...

    ITKE350,300 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • Error in running SQL Plus

    When running SQL plus of Oracle 9i, after giving user id and password protocol adapter error is there. I used both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • Is there a tool to trace queries in Oracle?

    I've been working with SQL Server over the past year but now I need to migrate an application with an Oracle database. When I trace my application queries, I used the Profiler tool in SQL Server. What would I be able to use in Oracle?

    ITKE350,300 pointsBadges:
  • JUN invalid identifier error message in Oracle SQL

    I'm currently working on a project that I need to display the number of employees that were hired for the past 20 years (1994). But I keep getting this error in Oracle SQL: "JUN' invalid identifier. What should I do? Here's my code: Select employee_id, count(*) From Employee Where...

    ITKE350,300 pointsBadges:
  • How to insert a UPSERT operation into an Oracle table

    I understand that UPSERT operation either updates or inserts a row into a table (depending if the table already has a row with matching data). Here's the code: if table t has a row exists that has key X: update t set mystuff... where mykey=X else insert into t mystuff... But in Oracle, it doesn't...

    ITKE350,300 pointsBadges:
  • DB2/400 to Oracle 10g

    I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration...

    792755 pointsBadges:
  • Deploy a .NET application that talks to an Oracle database

    Would there be a way to deploy a .NET application that talks to an Oracle database? If so, what would be required? Thanks for the help.

    ITKE350,300 pointsBadges:
  • How to add a boolean field to an Oracle table

    This past week, I've wanted to add a "Boolean field" to one of my Oracle tables. But I noticed that there's no boolean data type in Oracle. Is there a way to simulate it? A friend of mine told me to "Use an enum with the CHECK restraint." Is that the way to go?

    ITKE350,300 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