2,627 Topics
 | |
| | 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?  |
| | |
| | Hi all I have a heap corruption problem in getting STL containers data through OCCI methods . For instance if i do an assignment of this type [code] while(rs->next() ) { SRecord r; '' struct object r.PDM_APPLICATION_NO= rs->getString(1); r.PDM_FIRST_NAME=rs->getString(2);; //Error Heap Corruption r.PDM_LAST_NAME= rs->getString(3); r.PDM_F_FIRST_NAME= rs->getString(4); }[/code] I use Visual … |
| | hi, I need to create or replace a permanent query in access (like a view in oracle, postgres...), but from vb6 using ADODB. i know that i can create and alter tables using a ADODB connection object with something like this dim obj as new adodb.connection ... ... obj.execute "create … |
| | 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 … |
| | I am trying to execute a simple grep command in my shell script. I am not sure why it also greps the other file system. [COLOR="Green"]> df -g|grep /oracle/BP1/sapdata1 70.00 11.37 84% 21 1% /oracle/BP1/sapdata1 100.00 89.44 11% 8 1% /oracle/BP1/sapdata10 > df -g|grep /oracle/BP1/sapdata10 100.00 89.44 11% 8 1% … |
| | 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.  |
| | Hi, I'm new to Asp.net and I'm using Oracle database. I'm having no luck getting my gridview to update. When I test my update query in the datasource it updates but when I use the gridview it gives me this error "ORA-01036: illegal variable name/number". Please help.[code]<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ … |
| | |
| | Dear Sir, I am facing with login form coding I am first time try to working with oracle database. I am not able to connect through the login form Here is a screen short for you And code is here mention [code] Option Explicit Dim db As Database Dim rs … |
| | 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, While trying to debug some performance issues, we narrowed down the problem to calls to Entity Beans taking long time. Original design is nice and generic but does not scale up in this case. Here are the details: - J2EE application. - Oracle DB - Entity Beans used for … |
| | hi guys i have created a crystal report using crystal XI which accesses its data from Oracle Database through OLEDB.Now i am trying to call the report using VB6 and i get this error at the point of viewing the report. here is my code 'my connection string in a … |
| | 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 |
| | Site is working fine in mozilla and safari but not in Internet explorer. I am also trying to figure out how to put a picture next to the name on the other side. [B]Below is the css and the xhtml codes[/B] [B]CSS [/B][CODE]/* layoutstyles.css */ /* Background color of box … |
| | 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 … |
| | The aim of this thread is to gather useful information in regards of Java web development. If you know some tips and tricks, tutorials or any interesting links that has not been already mentioned in previous posts please share with us (please always check to avoid double posting). Please DO … |
| | hi all, iam familier to php forum here but completely new to vb.net, i am developing a web application using oracle database,vb.net and asp.net,just stuck up with generating manage content table with edit and delete you can see it in image file attached which is done in php here is … |
| | 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 - i have Oracle programming experience but i am new to HTML. Can somebody pls. help me translate attached image (Rates) into HTML code. The HTML code will be plugged into XML file. hxxp: img511. imageshack. us/img511/7827/rates. jpg I have some idea on HTML (very basic) see link below … |
| | Hi Actually i want to know the driver name to use for database connection using Oracle XE. |
| | Hello members! Could someone please give me a hand on this? I have a JTable in my program that display query resuslt when the user search for a patient by entering the surname, the result is supposed to display in JTable in another frame. Here is what I've done [CODE]import … |
| | [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 |
| | I m using a table GATE_PASS which has a primay key named GP_ID.the structure of GP_ID is 0000/MM/YY. I want to start a new series from 0000 after 30th june of every year.anyone could help me???? |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table … |
| | Hi..I am trying to connect oracle which is on my pc.i am using oracle 9i. i am creating 1 customer table & trying to display it. [code] import java.sql.*; import java.net.*; public class JdbcDemo{ public static void main(String args[]){ Driver d; Connection con; Statement stmt ; ResultSet rs; try{ d=(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); … |
| | Hi Guys Is there any function in C which will help me make an input string invisible while we are entering the input?? I mean similar to oracle login. when we type our oracle password at dos prompt it is not visible. My requirement precisely. 1) I want to read … |
| | I'm making a program that adds favourite programs, files and websites to an Oracle database so there is no longer a need to browse my pc to find those files. I'm stuck on trying to find a way to edit the database and refreshing the program so the edited data … |
| | What normal form is violated here? A telephone call is uniquely identified by telephone number and time of call. These candidate keys compose the composite primary key. There is an attribute/column “telephone location”. telephone number|time of call | telephone location(precise) Does it help if the telephone is mobile? Just thinking … |
| | Dear All, I'm developing a website which must have a link to an oracle database. does anyone knows how to configure OCI on a linux server. Thanks and Best Regards Dilbert137 |
| | A roundtable of industry licensing specialists has been discussing software ownership and liability in the complex new world tech order where cloud computing, virtualisation and Software as a Service reign supreme. Certainly there can be little doubting that over the course of the last 12 months or so CIOs and … |
| | ok so what i want to beable to do is have a coded up website template (with php in it) that is stored in the DB. and i would like to call it in a query. That part works fine but what doesnt work is the php being called from … |
| | Hello All. I am starting this new thread for the help of those who want to give oracle certification exam. I want help from all. I am about to give IZO-047 OCA certification exam after 15 days. Can anyone please provide me suggestion regarding the following things: 1. Book for … |
| | |
| | Would like to create a temp table at the start of my Code for pull only a small result set that I then can use for my final result. Thank you, David |
| | Dear All, I'm developing a project in php but seems to have issue connecting to an Oracle database 10g. I have got some examples on internet but is someone having the same issue or had a previous issue. Have someone a documentation guide to suggest me. Thanks Dilbert137 |
The End.