1,488 Topics
 | |
| | Im running windows XP Professional I have all of the latest updates on my laptop and I just downloaded the latest version of SQL Developer but when I try to open the program I receive this error “Unable to create an instance of the java virtual machine.” Ive been looking …  |
 | I have an app where I keep getting this error. This is a c# .net 3.5 app running on a windows 2003 server with IIS 6.0 connecting to an Oracle 10g db. This app had no problems during testing where it was connecting to an Oracle 9i DB but once … |
| | [CODE]<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Samples.Controllers" schema="I_USER" assembly="Samples" > <sql-query name="PROCEDURE1" callable="true"> <!--<return class="empdetails.cs" />--> <return-scalar column="iusrfname" type="String" /> <return-scalar column="iusrlname" type="String" /> <return-scalar column="iusrlinname" type="String" /> <return-scalar column="iusremailid" type="String" /> <return-scalar column="iusrmobileno" type="String" /> <return-scalar column="iusrrmrks" type="String" /> <!--<return-scalar column="iusrcreated" type="DateTime" />--> call PROCEDURE1(:pr_userid,:iusrfname,:iusrlname,:iusrlinname,:iusremailid,:iusrmobileno,:iusrrmrks)<!--,:iusrcreated)--> </sql-query> </hibernate-mapping>[/CODE] |
| | i want to connect an vb6 form with oracle9i so that i can insert update n delete ,what are all the ways i can connect to db , anyone help me with code , form one has four fields student name , id dept, year n college, if i click …  |
| | When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus. |
| | Oracle 10g I have been trying to import an excel .xls spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work. Is there a special formatting I need to do with excel(THE DATE COLUMN??)(I have tried just … |
| | This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: [CODE]Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, … |
| | |
 | It's true. [URL="http://www.oracle.com"]Oracle[/URL] is now, with its acquisition of Sun Microsystems, the world's largest purveyor of open source software. Does that surprise you? It did me too, until I started digging and realized that Oracle has a history of supporting free and open source software. Their support didn't start with … |
| | Hi I have to work with oracle application express 3.2 I have some doubt on installation: 1.whether i need to load oracle 9i release 1 or release 2 2.whether it is possible to work with windows vista/xp? 3. what are the requirements to install apex 3.2?? i am new to … |
| | I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import dates it does not work. is there a special formatting I need to do with excel? I have tried every step that I can possibly think of. whenever … |
| | hi there....... i m doing a project on matlab.......i wanna know how to connect oracle 8i or oracle 10g with matlab..... or whats d connectivity?? |
| | Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … |
| | Hi I am getting weird error with oracle connectivity. Immediately after the open() call, the connection shows as closed. I am not able to figure out whats going wrong. The same code works if executed differently. Line: This piece of code throws error [CODE=syntax] bool objState = false; if (Program.orConn … |
| | As a FOSS (Free, Open Source Software) advocate, I find myself in a state of shock over what I've observed over the past ten or so years in this realm. If I asked you to name the most successful open source companies (Companies that derive the majority of their income … |
| | Am using wordpress for web hosting. Stil now am using mysql database. But now i want use oracle is it possible or not please reply me any one... Thank you.. |
| | i am using oracle 8i.i want write a query to display who is the person & his tuple remitted or maximum amount used.how can i display it |
| | Hiya, Discoverer admin/desktop. There is this issue we do have in my place of work. We use a the tool called discover admin /desktop. The discoverer desktop is only accessible till 4:59pm exactly when it is 5:00pm it doesn't work and immediately it is 6:00pm it start working again. I …  |
| | Hiya, My company is about to up upgrade from Oracle Application R11.10.5.2 to R12. we a document to convince the management about the upgrade. We need to produce a document on why and how we can effectively migrate to Oracle Release 12, which include references to those who has concluded … |
| | hi can u tell me how to connect to oracle from jsp please.i |
 | I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: [CODE]select to_char(dateoftransport, 'MM-DD-YYYY') as "Date", dispatch_id as "Dispatch, vehicletype as "Dispatch Type" … |
| | Is it possible to create a trigger on a synonym on a database Links |
| | i am trying to simulate an alert for transaction being done on a bank account as my project but the person i asked to help me told me that using flexcube all i need is to execute the code below it would create a table OUTMESG which my own code. … |
| | I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare … |
| | can any of you help me by giving the project on library management system using VB6.0 and ORACLE 9i.... please friends... send me to email : <<Email Snipped>> |
| | hi, I have objects called Customer_obj , phonecall_obj , then I have tables of these objects where there is a reference to the customer table inside the phonecall_obj table. I try to pass the customer object in a stored function to search in the phonecall tables about that specific customer … |
| | Hello I am really new to Java/Oracle. I am having NetBean 6.8 IDE for development. jdk1.6.0_17 Where do I start? THANKS advance!!!!!  |
| | hiii i am doing a project using jsp and oracle.... i am stuck on one thing.... in my project i am asking the user some FAQs about symptoms he has.... depending on the answers he gives i want to show him probability of the diseases he may have... but i … |
| | |
| | what is major differences between sql server and oracle? |
| | |
| | I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number … |
| | I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had … |
| | Hello Friends, I have a small challenge, i need to motify a shell script designed to monitor an oracle database. It should notify the DBA when the listener & database is down and also notify when there is any error in the alert log. Note: The sendmail feature should not … |
| | I am trying to implement object inheritance with oracle 10g express. What i have done so far is created some types and subtypes. And some tables based on those types and sub types. So far i have understood that the subtypes inherit the attributes and methods from its super types. … |
| | Does anyone know anything about Oracle Roles & privileges. An application on 9i has multiple roles assigned to each user. I am getting permissions problems, I think because there are conflicting privileges within the roles. EG: Role1 has SELECT, UPDATE on table1. Role2 has SELECT, INSERT on table1. User Default … |
| | Knowing to be one of the most advanced Technology Provider across the Globe, The umbrella of Oracle has made space for JD Edwards, Sun, PeopleSoft, Siebel and many more technologies. You wanting to reach out to the technology users out in the market place does not necessarily require confinement towards … |
| | hello friends, Please help me . Currently i'm building my project using back-end in Oracle but i'm not getting the exact solution. I've idea about nvarchar datatype but it seems that i don't know proper use of it. so experts please show your talent to help me thanks regard |
| | Nipping problems and stakes at its bud is not the end of paving path towards success. If nipping problems forms the initial step of succcess marking, the second step is in formulating the right marketing strategy for the company.  |
| | |
| | Hello, I'm getting from an application log the following query: [CODE]select * from lxRO_4606b095 where lxToLat=:va and lxToId=:vb and lxType in (:vc,:vd,:ve,:vf,:vg,:vh) :va=1174843541 :vb=1959561595 :vc=1183424550 :vd=1183482004 :ve=1182541895 :vf=1182543699 :vg=1182550204 :vh=1182581348[/CODE] the problem is that this does not work in Oracle, there seems to be a problem with variable substitution. Is … |
| | Hi, I know there is an XML/Xpath topic already, but how about a SOA topic? Users can then post questions on Oracle SOA, Netbeans SOA, etc... Thanks, -Ashton.  |
| | kindly please tell me how to connect from java to ms access, sql,oracle and so etc . with example |
| | Hello. I am not getting the right idea to the oracle table in the list box so can anyone please tell me how can i list the oracle sql plus table's column in the listbox. Thanks in Advance. |
| | Having problems with connecting to an Oracle database, getting an error : Unrecognized attribute 'providerName' - Defined in web config : [<add key = "connection" value="Provider=MSDAORA;Data Source=TNSnames definition;Persist Security Info = True;Password=pass;user id =userid;" providerName="System.Data.OleDb"/>] program imports: [Imports System.Data.OracleClient Imports System.Data Imports System.Data.OleDb Imports System.Configuration Imports System.Object] help please...:0)  |
| | Hello every one I am trying to insert text into oracle 10g, which contains ( ‘ ) single quotes. I know its simple , I have tried google. This is the error I get Warning: ociparse() [function.ociparse]: ORA-01756: quoted string not properly terminated in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\qmon\age.php on line … |
| | While retrieving an uploaded file (stored in blob) from oracle database, junk characters are displayed at the start & end of the uploaded content. Also it does not show every line. Part of the code can be found below. Can anyone help or has some different solution?? [B]Upload.aspx.cs (Upload file … |
 | Hi there Can somebody please give me a link to a tutorial regarding materialised views/snapshots (preferably in Oracle) and perhaps some sample scripts too. Thanks in advance. |
| | Hi Actually i want to know the driver name to use for database connection using Oracle XE. |
| | [COLOR="Red"][/COLOR]hi frnds !!! I am an engineering student of 3rd year and i want to make a DBMS project so please suggest some good n unique projects on dbms. I'll be really grateful.Plz help me |
The End.