• Calling an Oracle function from hibernate with a return parameter

    We have a function which currently does some modifications internally and returns a value. This was our original idea: protected Integer checkXXX(Long id, Long transId) throws Exception { final String sql = "SELECT MYSCHEMA.MYFUNC(" + id + ", " + transId + ") FROM DUAL"; final BigDecimal nr =...

    ITKE350,945 pointsBadges:
  • Which Oracle certification should I choose?

    I have completed my BE CSE. I need to do an Oracle certification. I don't knno which is best one. Please guide me.

    karthik84185 pointsBadges:
  • How can I retrieve the highest five values of a column in Oracle

    How would I be able to write a query where only a select number of rows are returned with either the highest or lowest column value. I appreciate any help. Thanks.

    ITKE350,945 pointsBadges:
  • A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)

    Whenever I'm trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- A program is trying to automatically send email on your behalf Do you want to allow this? If this is unexpected it may be virus and you should choose no I don't want to show...

    44063860 pointsBadges:
  • Getting ORA-02436 when checking a constraint in Oracle

    I've been trying to check the following constraint but Oracle keeps returning an error. Here's what I have so far: ALTER TABLE Table1 ADD (CONSTRAINT GT_Table1_CloseDate CHECK (CloseDate > SYSDATE), CONSTRAINT LT_Table1_CloseDate CHECK (CloseDate <= SYSDATE + 365)), CONSTRAINT...

    ITKE350,945 pointsBadges:
  • Getting ORA-00979 error message with Oracle query

    In my query, I keep getting the ORA-00979 error message: SELECT cr.review_sk, cr.cs_sk, cr.full_name, tolist(to_char(cf.fact_date, 'mm/dd/yyyy')) "appt", cs.cs_id, cr.tracking_number from review cr, cs, fact cf where cr.cs_sk = cs.cs_sk and UPPER(cs.cs_id) like '%' || UPPER(i_cs_id) || '%' and...

    ITKE350,945 pointsBadges:
  • Generating an ER diagram using Oracle SQL Developer

    I'm trying to use Oracle SQL Developer to create an ER diagram for my Oracle database tables but I'm fairly new to Oracle / this tool. What would be the process of going about this? Thank you!

    ITKE350,945 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 pointsBadges:
  • View metadata of columns of a table in an Oracle database

    I'm looking for a query that allows me to view all the columns that are defined for a table in an Oracle database. Something along the lines of this: Table Name: Some_Table have 10 columns. So basically I want to how I can get the column names, data type and the constraints that are defined for the...

    ITKE350,945 pointsBadges:
  • 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,945 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,945 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,945 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,945 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,945 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,945 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,945 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