Search results for query: *

Hi folks - Just a little clarification to the question. Regarding the previous comments there is no source table where the updated table will get it's information from. In other words, the key information sent to this procedure comes from a calling JAVA application. I used the supplied keys...

I would like some guidance on this problem. Below is a Oracle stored procedure that will update a selected table row based on pass variables. The variable key fields sent to the procedure are used in a select comparison. I am getting a missing "FROM" syntax error when compiling the procedure...

Need to understand if the SQL code I created shown below is correct. A Java application is calling a Oracle 9i stored procedure to retrieve existing XML documents stored in a table. The Java application will send key fields (named: NODEID, DOCTYPE, and DOCREF). I will then used these fields...

Question : HOW do I PASS xmldata as an XMLdata type parameter to a procedure. We are using Oracle 9i rel 2. I built a relational table with xmldata type as a column: CREATE TABLE PRISM.NODALXML ( NODALXML_PK NUMBER(10), NODEID NUMBER(10), DOCTYPE...

How many processes can a Oracle 8i Listener support? I realized there are variables to this question such as server hardware configuration and such, I just need a reasonable guess. Our environment has 20+ Java applications accessing our database and performing selects, inserts, and updates to...

Hello, Environment> Oracle 9i release 2. I created a Oracle trigger that invokes a stored procedure when a row is inserted. Both trigger and procedure resides in the same schema. After a row is inserted in the table as shown in (exhibit A), it invokes a stored procedure that will load the row...

Hello, What is the best way to compare the columns in two tables for update? I have two tables containing the same column names and order running under Oracle 9i. Each table resides in separate schemas. In this situation I cannot use the Data Guard facility available under Oracle 9i. When the...

Thanks Dave, I will try this.

I need advice on a SQL problem. Here is the background info: I have two Oracle 9i tables. The column definitions in both tables are almost the same. One table has more defined attributes that the other. Each table are defined in separate schemas. User ID permission levels allows access to...

I have been studying the Trigger process. It is my understanding the Oracle commit action must first occur to make the new row available. Is this correct? I am creating a DataMart schema that will capture data (in real time) being inserted into a different database. Do I need to set up a...

Problem when updating table 1 based on table2 I am trying to update a table using information from another table. As shown below when I tried to update table ''commdev.comm_policy_activity_stg2'' I am receiving a expression error syntax message. I'm not sure what is missing. I would...

In the SQL shown below I am joining several tables in order to compare record count totals. How do you cause SQL to generate a exception error and abnormally terminate the procedure when any one of the columns being compared do not match...

How can I insert a record into a table when comparing two other tables? In the code shown below I am comparing two different tables. When a 'not exist' condition occurs I want to insert a new record into a third table. ============================================= select system_id, cycle_date...

Can someone please show me the correct method to automatically logon to Oracle from Access 97 via the SQL pass-through method. I am trying to eliminate the need for my users to manually logon (via ODBC) to the Oracle database. This is my code - - - begin "ODBC; Driver={MicroSoft...

How can I setup a progress meter for an Access 97 pass-through query? Using Oracle as the back-end server I have created several Access 97 queries that selects data from Oracle tables. Some of the queries take several minutes to run and I would like to display some form of a progress meter to...

Using Microsoft Access SQL pass-through, how do I invoke an Oracle procedure.