Search results for query: *

Greetings, Does anyone know of a freeware tool to determine the table structure and relationships of an Oracle database? I can link tables through ODBC but am having trouble determing the table relationships from the table names. Can't afford to purchase some of the commercially availble...

Please disregards my last post- found that it is part of the OS. Thanks everyone for your help! Got acess to the db through MS Access :). Now I only have to track down the IT guy who created the db to get the table structures and relationships..... Thanks Again Guinea pigs make the world a...

Thanks for your help! So I was following the instructions in the link you supplied and could not find the Microsoft ODBC administrator under Oracle home> Configuration and Migration Tools path. Is this an Oracle supplied program or Microsoft program? How do I go about getting it? I don't...

Greetings, Basic question. I searched the forum but could not come up with what I need. How do I connect to a Oracle database from access? I tried setting up and ODBC connection but couldn't get it to work. On my desktop I have 1)Oracle and Access 2003 2)a TNSnames entry that others use...

Hi there, We have an Excel macro that analyzes excel data which is currently less than 50,000 rows. Are needs are increasing and need to analyze databases of 100,000 rows or more so we need to go to access. How can we use Access to store the data and export chunks say 25,000 to Excel and have...

Hi There, I want to create a loopback connection on my w2k machine runing 8i1.6 to practice using the DBA studio tools on the database running on the same box. I was told if I use host 127.0.0.1 I can do this. My Tsnames= # TNSNAMES.ORA Network Configuration File...

Thanks pbxman I went to the link but the ASPI updater is not compatible with Windows2000 according to Sony. I hate to spend more money to get Nero when I just bought this CD-RW. Do you think it might be that my y2k just needs to be repaired or a clean install? I was able to get the software...

Hi There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and...

i There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and the...

Thanks Berton, So I do I need the SCSI/Raid drivers to run my hard drive or floppy? There is a separate driver to run the adaptec SCSI converter PCI card. In device manager I could uninstall one of the SCSI/RAID drivers (the one that is the same as 2' IDE) but do not have the option for the...

hi there, I am having trouble running some CD-R/RW software (B's Recorder Gold5) and get the message: "Stop:0x000000D1 (0x000000DB, 0x00000012, 0x00000000, 0xEB4571787) Driver_IRQL_not_les_or_equal" I assume it is a IRQ problem: IRQ Assignment 14 Primary IDE Channel 14 SCSI/RAID...

Hi there, I just installed a CD-R/RW into my Gateway PIII/450 mHZ computer. Windows 2000 PRO service pack 3 Config- CD-ROM -Slave for secondary IDE CD-R/RW-Master for secondary IDE scsi adapter in one PCI slot Ethernet card in another Printer hookedup to the parallel port one floppy- Slave for...

Hi CARP, Thanks for your response. I am still a little confused why I am getting this error. The schema scott is the default demo scott/tiger and I am loged on as system/manager. I can run the query in an SQL statement but not as a stored procedure? I should have select priveleges if I can...

Hi Everyone, I need to create a stored procedure that summarizes info in a table. I want to specify the schema that the table resides in. I tried this code create or replace procedure analyze_dept AS v_dept_record dept%ROWTYPE; BEGIN SELECT * INTO v_dept_record from Scott.dept; END; /...

Yes, that was part of the problem. I also needed to declare the records returned from the cursors. Thanks so much for your help!!!! '___' Hopefully soon I will have enough experience to contribute to the forum too. Below is the code that did compile without errors. CREATE OR REPLACE...

Thanks Karluk, Here are the results of the command LINE/COL ERROR -------- ----------------------------------------------------------------- 19/3 PL/SQL: SQL Statement ignored 21/18 PLS-00201: identifier 'V_CUSTID' must be declared 33/3 PL/SQL: Statement ignored 34/5 PLS-00364...

Hi Everyone, I am trying to convert the anonymous PL/SQL block to a function that is part of a package. anonymous block SET SERVEROUTPUT ON; ACCEPT p_cust_id PROMPT 'What is the customer ID: '; ACCEPT p_start_date PROMPT 'What is the start date (MM/DD/YYYY): '; ACCEPT p_end_date PROMPT...

That another a couple of other minor fixes and the script works like a charm. Thanks for your help. -Marc Guinea pigs make the world a nicer place! Piggydad30@hotmail.com

DOH!!! THANKS!! I WILL TRY THAT and see what happens. -MARC Guinea pigs make the world a nicer place! Piggydad30@hotmail.com

I have nested FOR loops to retreive two fields from a record. I then have IF..THEN..ELSEIF logic that compares one of the fields and uses the other field for a calculation. When I try to run this I keep getting errors: ORA-06550 Encountered the symbol "ITEM_TOT_RECORD" when...