1,488 Topics

Member Avatar for
Member Avatar for Primo

THE ERROR MESSAGE WAS: cannot delete oci.dll:Access is denied Make sure the disk is not full or write-protected and that the file is not currently in use. somebody help please

0
26
Member Avatar for mmondragon

can u kindly check what am i doing wrong? i tried using oci8 and the image is displayed but when i use adodb, my browser(firefox) says "problem loading..." can you give me some example of your code? thanks! [B]OCI8[/B] [I]<?php header("content-type: image/JPEG"); $getId = $_GET['id']; $User = "scott"; $Password = …

0
62
Member Avatar for jsp001

When submitting a page via the internet, I get a 500 error and the location of a file in jsp. Are you able to help?? Basically I have an expense system implemented with JSP in JBuilder 4 using Oracle 9i and SQL Plus. When submitting any pages in the system, …

0
58
Member Avatar for Joncamp

I would like to know if anyone has bench marked MySQL server, compared to Oracle. I have developed a database that will sort 1,000,000 records in less then 22 seconds (100 byte record sorting on 2 fields, and 1.3Ghz cpu).

Member Avatar for d66
0
93
Member Avatar for thiyag2001

Hi All!, I have a small query editer with a textarea and a buton.The user gives their query in the textarea and click the button it will returns the data to a datagrid.The use gives [B]SELECT[/B] query then the [B]data grid[/B] will give the data.suppose user gives [B]update or delete …

0
72
Member Avatar for gurnoor

i have to design a login form for my project with loginid and password.:sad: [B][U]Problems[/U][/B] 1) i have to store passwords in encrypted form 2) connectivity of asp.net with oracle 8i after cross checking of password and loginid next page should display details account so please help me on this:?: …

0
127
Member Avatar for hsharma65
Member Avatar for William Weeks

i'm using vb.net to create a windows form that will acces an oracle database to move records from one database to another. i keep getting the ORA-01000: maximum open cursors exceeded i do all of the close and dispose and gc.collect. rdr.close() rdr.dispose() cmd.dispose() con.Close() con.dispose() my dba tells me …

0
85
Member Avatar for oracle_dev

Hi, I want to create a button which, when pressed, calls a procedure passing certain parameters to it. How do i do this? htp.formsubmit...? Thanks

0
84
Member Avatar for arsmizzou

i'm having trouble figuring this out b/c i have the version of oracle that doesnt support ora_numcols, etc... anyways, here is my query... $query = "SELECT DISTINCT S.FName, S.MName, S.LName, S.Address1, F.Value, F.Feature_id, S.zip, S.Student_id FROM Student S, AwardedScholarship P, stu_feature F WHERE P.Is_Pending = 'Y' AND F.Feature_id in (" …

0
86
Member Avatar for arsmizzou

i'm having trouble figuring this out b/c i have the version of oracle that doesnt support ora_numcols, etc... anyways, here is my query... $query = "SELECT DISTINCT S.FName, S.MName, S.LName, S.Address1, F.Value, F.Feature_id, S.zip, S.Student_id FROM Student S, AwardedScholarship P, stu_feature F WHERE P.Is_Pending = 'Y' AND F.Feature_id in (" …

0
65
Member Avatar for Subhashish

I want to write a PL/SQL Stored Procedure. A Project is created in database. Please help me in applying the following logic in stored procedure. " Project start date and end date are stored in project_date table. Whenever the project start date and end date are amended from oracle forms …

0
75
Member Avatar for arsmizzou

can anyone help? thanks! <?php include_once "mysql_connect.php"; mysql_connection($dbc); $select = "SELECT DISTINCT D.Title, D.FirstName, D.MiddleI, D.LastName, D.Suffix, D.Address1, D.Address2, D.City, D.State, D.Zip FROM Donor D, Pre_award P, sch_donor S WHERE Approved = 'y' AND S.Did = D.Did AND S.Scholarship_id = P.Scholarship_id"; $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i = …

0
70
Member Avatar for arsmizzou

can anyone help me out? <?php include_once "mysql_connect.php"; mysql_connection($dbc); $select = "SELECT DISTINCT D.Title, D.FirstName, D.MiddleI, D.LastName, D.Suffix, D.Address1, D.Address2, D.City, D.State, D.Zip FROM Donor D, Pre_award P, sch_donor S WHERE Approved = 'y' AND S.Did = D.Did AND S.Scholarship_id = P.Scholarship_id"; $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i …

0
57
Member Avatar for shahnazurs

Good Morning Friends, Could you please tell me how to send mail to more than one recepients along with attachment? I know we have to use UTL_SMTP package for this, i need full snippet. Many thanks

0
101
Member Avatar for shahnazurs

Please help me about knowing what is semaphores in oracle as well as what is the use of DBMS_ALERT package in oracle 8i or later...with some nice examples. Many Thanks, Shahnaz

0
68
Member Avatar for tannukumar
Member Avatar for teman_siber

hi, can anyone help me how to store the image in oracle using JSP. plz...urgent.. can anybody give me the sample codes.. thanks

Member Avatar for jwenting
0
77
Member Avatar for stoyka

Hi, I have to build up an web application (ASP.NET) that communicate with its own Oracle database. Also this application should write some data (like inovices, payments) into Oracle Applications 11i database. Do someone knows how could I implement these features? Is there any Oracle API that I can use …

0
74
Member Avatar for djbsabkcb

How would you display in your sql a column of brackets [ ] with a field width of five spaces in between?

Member Avatar for jim mcnamara
0
94
Member Avatar for indianscorpion2

hi everyone. i am an amateur programmer in java. can anyone please tell me how do i go about connecting my java application to oracle 9i database? please be specific about what is the URL that i should use and how should i install the oracle JDBC driver.where should i …

Member Avatar for jwenting
0
218
Member Avatar for aep91

i try to make a select table with condition now such as; <? ... $res = $conn->Execute("SELECT ID_SKENARIO,DATE_I FROM T_SCENARIO WHERE DATE_I = NOW"); While(!$res ->EOF) { echo $res->fields[0]; } ... ?> what is the right synta for condition date is now ? please help me... :sad:

Member Avatar for aep91
0
132
Member Avatar for jkushner

i am interested in knowing how to make my resultset updatable. i am currently running jdk5.0 so it should already acquire such information, but the following code is throwing me errors. public String execute( String newPassword ) throws ClassNotFoundException { //private variables Connection conn = null; Statement stmt = null; …

Member Avatar for jkushner
0
115
Member Avatar for cltsoi

Could anyone tell me: The different of development effort spend to develop the web-based application on Oracle RDBMS and Oracle XML DB. Is it difficult to develop something on Oracle XML DB? The functions are normal maintenance operations such as add, delete... Moreover, how about the SECURITY function? How to …

0
86
Member Avatar for shobana

I am final year student. I am going to do the projet in visual basic and oracle in IVRS. i want the details of ivrs and how to record the voice, how to get the response with keypress without using any trial version software. i didn't have much knowledge in …

Member Avatar for shobana
0
186
Member Avatar for cltsoi

How to convert Tamino XML DB Server to Oracle XML DB Server and/or Oracle RDBMS DB Server? I got 240GB data stored in Tamino XML DB server. My clients request to convert them into Oracle. Since I am not familiar with Oracle XML DB Server (latest and stable version is …

0
81
Member Avatar for djbsabkcb

Hi, Below is code to gather information from a beg and end date but hwo would I generate information on each day of the week. Sunday - Saturday for a set of specific date ranges? [code] Select Count(b.max) From lm.dw a, lm.bw b Where (a.Start_dt <= getdate() and a.End_dt >= …

Member Avatar for jim mcnamara
0
97
Member Avatar for djbsabkcb

Can anyone suggest a good beginner book for learning Oracle and SQL that they have used or know someone who has ? sabd

Member Avatar for jim mcnamara
0
98
Member Avatar for tukai

Hello guys, I have [COLOR=DarkSlateBlue]Oracle9i[/COLOR] installed in my homepc and my O.S. is [COLOR=Navy]Windowsxp-professional[/COLOR]. Now,I want to connect Vb using [COLOR=Indigo]Microsoft OLE DB Provier for oracle[/COLOR]. For this i have done the following steps--- 1. Created a text document and renamed it with extension .udl 2. On openning the file …

Member Avatar for jim mcnamara
0
103
Member Avatar for shaji

I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login …

Member Avatar for hooknc
0
175

The End.