1,488 Topics

Member Avatar for
Member Avatar for jpri

hiii I am doing application in vb.net and Oracle10g. On running the project there is some "Query Engine Error C:\document\Local\temp\....3434834-453493434.rpt" error but when same dataSet object when set as source to Datagrid the grid is filled corretly.......... any idea where m i going wrong...............

0
48
Member Avatar for palavi

Hi All, I am able to connect to the database from backend that is toad.But from the java application i can't . The error is from the line [CODE]Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@vrs1.india.mitey.com:1591:dapps");[/CODE] I am getting the following error: [CODE]Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7 at oracle.security.o3logon.C1.r(C1) at oracle.security.o3logon.C1.l(C1) at …

Member Avatar for palavi
0
256
Member Avatar for senthilg

HI friend can you tell me how to connect and retrieve data from mySQL and oracle database using ado.net in C#.

Member Avatar for kvprajapati
0
36
Member Avatar for Roybut

Hi, I have this view: [CODE]DROP VIEW digits; CREATE VIEW digits AS ( SELECT TO_NUMBER(SUBSTR(rounded_cost, 1, INSTR(rounded_cost, '.' -1))) left_digits, TO_NUMBER(SUBSTR(rounded_cost, INSTR(rounded_cost, '.' + 1, LENGTH(rounded_cost)))) right_digits FROM roundcost );[/CODE] It allows me to create it but the values stored are apparently not valid numbers. When I try select * …

Member Avatar for naziatarannum
0
130
Member Avatar for Blaine Tuisee

I currently run an installer app that will install a DB on a VM server. However this fails because the when oracle is called to begin the oracle services start up but the newly installed DB will not. It works on a physical machine but not on the virtual server. …

0
73
Member Avatar for vasanth19

Has someone managed to install Oracle 11.1 on Fedora 12 ? The following packages failed to install : Checking for libaio-0.3.106-i386; Not found. Failed <<<< Checking for libstdc++-4.1.1-i386; Not found. Failed <<<< Checking for libgcc-4.1.1-i386; Not found. Failed <<<< Checking for glibc-devel-2.5-i386; Not found. Failed <<<< Checking for compat-libstdc++-33-3.2.3-i386; Not …

Member Avatar for vasanth19
0
579
Member Avatar for fawkman

Hey guys I am Using Oracle APex and have created a some tables running SQL commands. I am now trying to INSERT multiple rows of data into one of the tables but am running into issues. I firstly tried the following: [CODE]INSERT INTO stock_item_table (stock_item_no, item_desc, item_price) VALUES(11,'item1',12); VALUES(12,'item1',22); VALUES(13,'item1',32); …

Member Avatar for fawkman
0
1K
Member Avatar for pranavdv

Hello friends, i m trying to input user : scott and pass : tiger also trying user : system pass : manager but even though its not going to start. i m getting following error [QUOTE]SQL*Plus: Release 3.3.4.0.0 ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: Enter password: ERROR: …

Member Avatar for debasisdas
-2
350
Member Avatar for manimala.uma

Hi, I was new to c# and asp.net .I want to create a simple login page using ASP.net with c# code.I had 2 textboxs(username and id) and 1 button control.I stored all the username and id in oracle database.Ma table in database contents emp_name & password.what i need is ,once …

Member Avatar for nazee
0
2K
Member Avatar for CaffeineCoder

Hello! I'm trying to install an Oracle application onto Win XP SP2 and am getting the following error: user1.pin(20): OS_ERROR while spawning ifsrv60 -install Forms60Server port=9000 mode=Socket batch=yes Any ideas on this?? Having difficulty resolving this issue.

0
92
Member Avatar for ceyesuma

The name of this question is “three JSF questions” Hello and Thank you in advance for any assistance. [B] System info: [/B] Netbeans,MySQL,glassfish [B] The Purpose of this post is: [/B] have someone look at the excel file (subscribe_app_notes2)at : [url]http://cid-b5cb457363230793.skydrive.live.com/browse.aspx/Public[/url] [B] The functionality of this code is: [/B] I …

Member Avatar for ceyesuma
-2
86
Member Avatar for Gatayo

Design an oracle for the following JavaScript function. 2. Generate a test case set for this function and provide a coverage analysis report for your test case set. The JavaScript function: [CODE=javascript]function purchaseSong(username, password, songId) { // first authenticate the user if (checkCredentials(username, password) == false) { alert('The username or …

Member Avatar for Gatayo
-1
108
Member Avatar for greenerworld007

Hi, I need to get Oracle for windows 95 including sql plus 8.0 for practicing my subject. no other version would do. Can someone please give me the download link. thank you.

Member Avatar for khakilang
0
58
Member Avatar for Lioshenka

Stupid question, really... Say, if I have a Department tuple with "Faculty" field- how can I declare it on the design stage so it only can take the values of "Science", "Arts" or "Psychology"? Department { <letter_ID : CHAR( 2)>, <english_name: VARCHAR2 (50)>, <enw_cymraeg: VARCHAR2 (50)>, <faculty: "science" or "arts" …

Member Avatar for debasisdas
0
49
Member Avatar for ceyesuma

The name of this question is oracle project Hello and Thank you in advance for any assistance. [B] System info: [/B] I presently use Netbeans6.7,MySQL,glassfish to work with learning JSF and java apps etc. [B] The Purpose of this post is: [/B] I recently was presented with a tutorial to …

Member Avatar for ceyesuma
0
170
Member Avatar for flaskvacuum

i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use only one data file. here is what i know: [CODE] CREATE TABLESPACE TABLE1 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K DATAFILE 'C:\ORACLE\ORADATA\MYDB\TABLE1.DBF' SIZE …

0
61
Member Avatar for fh84

Hello to all, Am new to oracle sql, and I am using the developer to create new database. Unfortunately, when I try to create new connection and error appears saying that : Status: failure –lo exception. The network adapter could not establish the connection. Connection Name: NewDatabase Username: test Password: …

Member Avatar for debasisdas
0
85
Member Avatar for plut0564

Hi, I've suddenly started getting some errors reported in my apache error_log on Windows 2003. The apache has been running fine and we've not upgraded it. I've now getting this in the error_log, [Wed Nov 11 09:42:28 2009] [crit] (10038)An operation was attempted on something that is not a socket: …

Member Avatar for Bob_180_Bob
0
265
Member Avatar for ArunRaj.SRM

Hi, Can anyone provide a sample application that usses a login page, in which users can login and the login details will be checked from the oracle db. Thanks in advance.:)

Member Avatar for peter_budo
0
85
Member Avatar for CSG-SQU

helllllo >>> i have worked on Functions and precuders in PL/SQL for alsmost two weeks until now !! ummm i had some blocks where i stop with >< having no idea how to deal with !!! one of those blocks checks wether a member team is nethier Manager non a …

0
56
Member Avatar for baheddad

hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user.

Member Avatar for whizkidash
0
201
Member Avatar for sri4shell

Can any one please let me know how to connect to oracle retrieve data and work around the data through shell script. for example i have to get salary of 5 employees and add 500 to them and print them. thanks a ton in advance. Sriram

Member Avatar for scripter.online
0
413
Member Avatar for cjmartin

I have tried several different things with none providing the correct results. Any help is appreciated. I have the following: Table A Table B Pallet_No Pallet_No Qty Qty I need to return: - All of the Pallet_No's from Table A that are not in Table B - All of the …

Member Avatar for debasisdas
0
122
Member Avatar for pritesh007

Hi, i m simran,a be student of cs .i want to make a project an minor project on any topic.plz help me plz rep quikly. Thank you.

Member Avatar for debasisdas
0
131
Member Avatar for johnbach

I have around 2 million vouchers of some fixed denomination (say 10 and 20)[CODE]create table vouchers(pin varchar2(20) primary key ,amount number,status char(1),extra_value number); create index IDX_AMOUNT_STATUS on vouchers(amount,status);[/CODE]Typical values [CODE]amount,status ,count(status) 10 N 1000000 10 U 700000 20 N 300000 [/CODE]For each payment transaction,I fetch one voucher wrt.transaction amount and …

Member Avatar for johnbach
0
166
Member Avatar for richard bach

hey i'm starting with a dbms project on commonwealth games . i want to use sql . can anyone please suggest me with what all i can include in my project??

Member Avatar for debasisdas
0
91
Member Avatar for samehsenosi

[B]hi every body i have a trouble with viewing the report from using the following environments[/B] C# - Crystalreport - Oracle database i regularly use the basic way to call a view form the database and extract the data form it like that [CODE]cmd.commandtext= "Create view as select * from …

Member Avatar for DdoubleD
0
142
Member Avatar for fazepage

I have an assignment that states >Research on Microsoft SQL Server, Oracle, and MySQL. Briefly describe each database application. What are their inherent benefits or limitations? Assume a pro or con approach: Based on your research, which would be the most reasonable approach to this solution and why> All i …

Member Avatar for deas1997
0
166
Member Avatar for needhelp//

can anyone say me how to insert the string of combo box into the table in oracle... from VB pls anyone help me with the code....:sad:

Member Avatar for needhelp//
0
121
Member Avatar for christiangirl

I am just starting to learn sql and have to questions from my homework assignment. The first is this: Write a query which will project the average rental price and number of such videos for videos of Classic movies --- BUT! You must write this without explicitly using the category …

Member Avatar for debasisdas
0
96

The End.