Oracle 10g

Oracle Developer 10g Express Edition and Oracle Database 10g

can we use same edition at same time? like we are use express edtion of oracle databse 10g and also use oracle developer 10g express edition at same time?

Oracle, MySQL connectivity by HSODBC

Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both...

Migrating from Sybase to Oracle 10g

I know the a little more than the basics of DBing but not as much as an OCA or OCP. I need to know how to migrate data over from Sybase to Oracle 10g on a very large scale! Please help! I do not want to use a conversion software because there are many updates to the Oracle architechture already....

Monitoring Object changes in Oracle

I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don't like. I question is how to find out who modified an object in 9i or 10g (and 11i)?

Integration of Oracle Reports with Oracle Forms

how to integrate oracle reports in developer suite 10g with oracle form

Send email via Oracle Forms

how do i send email with attachment using oracle 10g forms

Searching using Oracle Forms

Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter...

form10g error

FRM-10142:The HTTP Listener is not running at port 8224. please restart the listener or check your runtime preferences

Oracle forms app run on Client

Hi, I have an application migrated from DS6i to DS10g. I can run it from the server where i have installed all required product. I want to run it from my client PC. I have installed JINI on client. But i can not run my app in client IE Browser. What kind of setting i have to make in Client side...

Develop Oracle application by 4GL

i am good devoloper in 4gl under informix under platform unix i tranfer to oracle 10g under window 2003 server would you please give me tools to write my own 4gl program in using oracle database under windows

Oracle reports

what is the method of run\call report on form in oracle developer 10g?

Table replication

How i can Replicate the table in oracle 10g

reports erver in oracle 10g

how to creat report server in oracle 10g & run the report

how to list forms and their base tables

oracle 10g, forms 6i. v have 500 forms & 3000 tables. v find it hard to find which tables getting data from which tables. How to take a list of forms and their corresponding base tables. v don't want to check each form with form builder.

Data Scrub in Oracle 10g

I am looking for algorithm for Data Scrub in Oracle 10g - I work with sensitive data and I need to get some help as to how to go about this and if any body can come up with some codes, I really appreciate that. There are some ready made softwares available, but I am interested in getting to know...

Question on Oracle Forms 10g

Hi I have a requirement of reading a document sitting on a client machine on the network and printing the same from a Oracle Forms screen. The document is not necessariy on the OS of the machine from which I access the form, it is most times on other machines on the same network. The input I...

When do I use a collection instead of a table

I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists. I was wondering if that is the most efficient way in oracle. I read about...

How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

Oracle ignores hints

Oracle 10g does full table scan when he should use index specified in HINT

10g/10app server Forms not running on Dell machine.

We have custom web forms that have a fit running on Dell Optiplex gx520 and 620 machines. After updating the jvm.dll so jinit 1.3.1.22 will run on IE7, Dell Optiplex gx520 and 620 machines begin to run the app but then a message reading something like "The instruction at memory location XXXXXXXX...