Oracle

can VS 2005 support Oracle 10g?

can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

View Answer   |  Jul 22 2008   8:04 AM GMT   |  asked by KPL
VS 2005, SSRS, Visual Studio

Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit

We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory...

View Answer   |  Jul 22 2008   1:41 AM GMT   |  asked by KGA
Windows Server 2003, Oracle 9i

autobackup

How do you enable the autobackup for the controlfile using RMAN

View Answer   |  Jul 20 2008   2:57 PM GMT   |  asked by Narmada
Oracle Recovery Manager, RMAN, Oracle backup

Installing oracle 9i

is it possible to install qracle 9i on a windows 2003 environment

View Answer   |  Jul 20 2008   10:02 AM GMT   |  asked by Rr242418
Oracle installation, Oracle 9i, Windows Server 2003

Suggestion/reminder How to get your question answered

This just an open reminder for all who post questions or plan to post questions. It is much easier and faster to provide an answer when you remember to include details such as what version of the product you are using. If there is an error message, please post the exact error and event id if...

View Answer   |  Jul 18 2008   6:26 PM GMT   |  asked by Technochic
ITKE, Lotus Domino, Oracle

Oracle coding error ORA-06550

Hi,I get the following error on compiling my code -***********************************************************ORA-06550: line 16, column 1:PLS-00103: Encountered the symbol "ELSE" when expecting one of thefollowing: begin case declare end exit for goto if loop mod null pragma raise return...

View Answer   |  Jul 18 2008   2:59 PM GMT   |  asked by ITKE
Oracle development, Oracle error messages, ORA-06550

Syntex for storing combobox & redio button in oracle using VB.NET

How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????

View Answer   |  Jul 18 2008   11:52 AM GMT   |  asked by Deep 0607
ComboBox, Oracle database design, VB.NET

Oracle App Server webcache and mod_gzip

Hi all,I am struggling since last few days to work these both together.Problem is: The web cache is compressing the content but i don't want it to compress, i want the compression from server through mod_gzip. Even if i m disabling compression in webcache settings, its not working. In mod_gzip log...

Answer Question   |  Jul 18 2008   11:26 AM GMT   |  asked by Mthakur
MOD_GZIP, Oracle Application Server, Oracle error messages

OpenLDAP and Oracle Database

Hi,This is a question related to Oracle and OpenLdap.Can anybody please tell me how to setup the Oracle [10g] to use the installed OpenLdap server.I know we need to use netca and use the internet directory services; But how to set Open Ldap is the question here. Your help is greatly...

Answer Question   |  Jul 17 2008   5:48 PM GMT   |  asked by Parthahs
Authentication, Oracle 10g, OpenLdap

report server error using oracle 10g

Hi. I an using oracle 10g.when i run 10g reports individually it works finebut when i try it to connect with forms it gives error 'cannot connect toserver'please help how could i connect it to server.

View Answer   |  Jul 17 2008   9:11 AM GMT   |  asked by Raza
Oracle 10g, Oracle Reports, Oracle error messages

How to deploy database application built on VB 6 and Oracle?

I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.

View Answer   |  Jul 16 2008   3:51 PM GMT   |  asked by OracleATE
Oracle 8i, VB6, Database programming

How to create a trigger for updating a table for a quantity decrease?

How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column?1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions.2. The trigger must fire for each row that is...

View Answer   |  Jul 16 2008   3:48 PM GMT   |  asked by OracleATE
Oracle development, Triggers

ORA-12801 and ORA-01008 when running Oracle Reports

When I run the report from report builder I get following errorORA-12801: error signaled in parallel query server P001, instance db12:testdb(2)ORA-01008: Not all variables boundAny idea what could be the problem? Database is Oracle 10g.

Answer Question   |  Jul 16 2008   3:45 PM GMT   |  asked by OracleATE
ORA-12801, ORA-01008, Oracle Reports

WIN2003 or redhat linux which is the best for oracle e-business

dear what will be better for oracle e-business linux or win2003 ... here we face problem for linux professionals but can easly get win professional.. but at the same time we are thinking for security and stability etc.. we are new to linux but have experience on win2003.. plz share your experience...

Answer Question   |  Jul 16 2008   3:14 PM GMT   |  asked by Now now101
Oracle E-Business Suite, Red Hat Linux, Windows Server 2003

In DBCA, Its not Showing all the database in the list

In DBCA,After selecting the " ORACLE SINGLE INSTANCE DATABASE" and Click next Button,There In list of Available database its not Showing all the database in that serverPlease let me know where we specify those database name to be picked by DBCA,I have checked in TNSNAMES.ora & LISTENER.ora but no...

Answer Question   |  Jul 16 2008   6:17 AM GMT   |  asked by Ganeshpp
DBCA, LISTENER.ora, TNSNAMES.ora

export data based on date

Hi i'm new to oracle how can i use the export command to export data based on date and subsequenly purge the data exported from the database?Thanks for any info

Answer Question   |  Jul 16 2008   3:55 AM GMT   |  asked by Fartman
Oracle database export, Oracle export

Getting the number of a row from a flat file source in SQL

How might I get the number of a row from a flat file source with a script component in SQL?

Answer Question   |  Jul 15 2008   6:42 PM GMT   |  asked by SQL Server Ask the Experts
SQL, ROW_NUMBER, Scripts

ORA-27101 error when migrating Oracle 9i to AD domain

We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this:ORACLE not available ORA-27101When we back out of the changes, everything works fine again. Any ideas? Thank you.

Answer Question   |  Jul 15 2008   5:22 PM GMT   |  asked by OracleATE
ORA-27101, Oracle 9i, Oracle migration

How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?

I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created - as i can switch between them using the Home Selector.I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling me only...

Answer Question   |  Jul 15 2008   5:17 PM GMT   |  asked by OracleATE
Oracle Import/Export, Oracle 10g, Oracle 9i

Best backup procedure for Oracle E-Business Suite?

We are using Oracle E-Business Suite R.12. Database and applications are running in two different nodes under hp-ux in NoArchivelog mode. In this scenario, a backup procedure is to be created. Can you suggest to me the steps involved in taking backup of both database and applications node,...

Answer Question   |  Jul 15 2008   5:11 PM GMT   |  asked by OracleATE
Oracle E-Business Suite, HP-UX, Oracle backup