can VS 2005 support Oracle 10g?
Hello, There are several white pages that are available for this information… http://whitepapers.silicon.com/0,39024759,60300919p,00.htm and http://whitepapers.techrepublic.com.com/abstract.aspx?docid=349049 are a couple of samples… Hope they help,

View Answer   |  July 23, 2008  9:34 PM
Oracle 10g, SSRS, Visual Studio, VS 2005

Oracle 10g Enterprise Manager Console – Sort Schema list
I too ran into the same issue and it took a little playing around to figure it out. If you go to Navigator menu and select “Navigator Preferences” you should have an option to Categorize Schema Objects “First by oobject type then by schema”. Select that and they should be sorted.

View Answer   |  July 22, 2008  1:50 PM
Database, Oracle, Oracle 10g, Oracle Enterprise Manager

Confused!!!!!!!!!!!!!!!!!!!
Hello H, I assume that you have 4 years of experience in your computers business. Primarily it is important to understand was it totally hardware, software, or both. Moreover when you say you have a little bit of knowledge of everything, every platform and every technology, then probably you have to assess your knowledge and [...]

View Answer   |  July 22, 2008  8:05 AM
.NET, Java, Oracle

Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit
Check if 16GB RAM is recognized by your server with Win2003 in ‘properties’. if it does not, check with server specs how much maximum RAM it can support. If it supports 16GB and the performance is ditto same as was with 4GB, take a backup of your database, reinstall OS and Oracle 9i and restore [...]

View Answer   |  July 22, 2008  5:07 AM
Oracle 9i, Windows Server 2003

Installing oracle 9i
100% sure regards,

View Answer   |  July 20, 2008  1:56 PM
Oracle 9i, Oracle installation, Windows Server 2003

Suggestion/reminder How to get your question answered
Also, in the tags, please be more specific than outlook, or exchange for instance. Include outlook 2003 or outlook 2007 for instance instead of just outlook, or include exchange 2003 or 2007 instead of just exchange, and how about windows vista or windows xp instead of just windows. These details make all the difference when [...]

View Answer   |  July 18, 2008  6:30 PM
AS/400, Database, Development, Exchange, ITKE, Lotus Domino, Oracle, SAP, Security, Storage, Virtualization, Windows

Syntex for storing combobox & redio button in oracle using VB.NET
For Combo Box and Radio buttons you would typically store the numeric value associated with the value displayed on the screen. This would normally be done via the .VALUE method of the object.

View Answer   |  July 18, 2008  5:53 PM
ComboBox, Oracle database design, Oracle development, VB.NET

Oracle coding error ORA-06550
One suggestion too all of the new bees, take time and and take a good look and alakyze your code, other wise you will send your code these sites all the time. Here is your right code. “BEGIN” inside the loop didn’t have “END” DECLARE str VARCHAR(255); BDGroupArea VARCHAR(255); pos INTEGER; BEGIN BDGroupArea := ’1,2,3′; [...]

View Answer   |  July 18, 2008  5:12 PM
ORA-06550, Oracle development, Oracle error messages

report server error using oracle 10g
Where are you trying to run this report, AS or local machine? Just to clarify you need a report server in local machine or report services to run the report through forms, both have different method to start. What I think is you are trying to call the report in your machine (Window based). Here [...]

View Answer   |  July 17, 2008  4:48 PM
Oracle 10g, Oracle error messages, Oracle Reports

How to create a trigger for updating a table for a quantity decrease?
You need to create two triggers one is row level where you will move your ID’s into a global staging area (may be a table of record or temporary table), then in the statement level trigger you will handle all the updates on the ID’s which you have saved in row level trigger. The reason [...]

View Answer   |  July 16, 2008  8:11 PM
Oracle development, Triggers

How to deploy database application built on VB 6 and Oracle?
There are a number of ways to “export” the table definitions from Oracle. It depends on your desired use. Oracle has an export utility which you can use to export. On a UNIX system, the command is “exp”. There are various options to export just definitions (schema) or both schema and data. The generated file [...]

View Answer   |  July 16, 2008  5:49 PM
Application deployment, Database programming, Oracle 8i, VB

How to call a report made in Reports 6i into a Forms 6i Form.
WRITE THIS CODE “WHEN BUTTEN PRESS” ON YOUR FORM DECLARE PARAMID PARAMLIST; BEGIN PARAMID :=CREATE_PARAMETER_LIST(‘TEMP’); ADD_PARAMETER(PARAMID,’PARAMFORM’,TEXT_PARAMETER,’NO’); ADD_PARAMETER(PARAMID,’****’,TEXT_PARAMETER,:block197.****); ADD_PARAMETER(PARAMID,’DESTYPE’,TEXT_PARAMETER,’SCREEN’); RUN_PRODUCT(REPORTS,’C:******.rep’,SYNCHRONOUS,RUNTIME, FILESYSTEM,PARAMID); IF NOT(ID_NULL(PARAMID)) THEN DESTROY_PARAMETER_LIST(PARAMID); END IF; END;

View Answer   |  July 14, 2008  2:34 PM
D2K 6i, Developer 2000, Oracle Forms, Oracle Reports

TNS-03505: Failed to resolve name
I have not worked a lot with Linux, but have worked on other UNIX operating systems for numerous years. Does the server/host have a valid IP address or hostname other than the loopback IP? Do you have a default domain? I would suggest not using the loopback IP as your host. Is there a hostname [...]

View Answer   |  July 11, 2008  9:13 PM
Oracle 10g, Oracle error messages, Red Hat Enterprise Linux, RHEL, RHEL4, TNS-03505

how can i resolve oracle error 00103
I am far from an expert in PL/SQL, but I believe you need to have an “END;” prior to the END LOOP: to match your Begin statement. ie COMMIT; END; END LOOP; END; /

View Answer   |  July 11, 2008  8:53 PM
ORA-00103, Oracle 9i, Oracle error messages, PL/SQL

Oracle/Unix What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.
That depends on what you are comparing to. Automated testing tools have a great advantage over trying to manually test database performance. Please clarify your question.

View Answer   |  July 8, 2008  8:59 PM
Oracle, Oracle performance, Unix, Unix Solaris

can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
The standard SQL approach would be “select count (*) from tableName”. Some DBs maintain internal counters that return this result as a simple lookup rather than having to actually count each individual row. Without knowing anything on Oracle 9i specifically, I would guess that it’s one of those DBs.

View Answer   |  July 8, 2008  3:22 PM
Oracle 9i

Linked Servers????
Check out a product called Spiceworks….works great for me and includes a help desk…. From Ritchie1: the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put [...]

View Answer   |  July 4, 2008  9:46 AM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003

Backing up and restoring a LIVE database in SQL Server 2000
Indexes are backed up as part of the full database backup. One reason why the database will be running slower is because the live database has most of the database in cache already, while the server you are restoring to does not have any of the data in cache. All the data needs to be [...]

View Answer   |  July 2, 2008  8:22 PM
Database backup and recovery, Indexes, LIVE database, SQL Server 2000

Update deactiviting and throwing ora-600 error
Try using the Oracle Metalilnk ORA-600/ORA-7445 Troubleshooter Tool. Refer to the note 138330.1. This is a known Oracle bug.

View Answer   |  July 2, 2008  4:10 PM
ORA-00600, Oracle development, Oracle error messages, Oracle SQL

how to access fields of table along with their datatypes in oracle
You need to use ALL_TAB_COLUMNS or ALL_TAB_COLS to get the columns information for a table.

View Answer   |  July 1, 2008  6:05 PM
Developer 2000, Oracle 9i, Oracle Developer 2000, Oracle development