Archive for the ‘Solve Problems’ Category

Oracle DBMS_SCHEDULER Part 2 – The API

Read the rest of this entry »

Oracle DBMS_SCHEDULER Part 1–The Basics

Read the rest of this entry »

Agility and Analysis

Read the rest of this entry »

Designing the Data Mart – Part 2

Read the rest of this entry »

Designing the Data Mart – Part 1

Read the rest of this entry »

PL/JSON v0.6.2 Released

Read the rest of this entry »

Use a Pipelined Function to Select Source Code Arguments

Read the rest of this entry »

Stupid Database Tricks – Shutdown the server from a stored procedure

Read the rest of this entry »

Calculating Business Days and Business Days Between

Read the rest of this entry »

JSON In (and out) of Oracle – JSON Data Type

Read the rest of this entry »

Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API

Read the rest of this entry »

Oracle Data Types – 5 FAQs About Number

Read the rest of this entry »

View PDFs on a BlackBerry

Read the rest of this entry »

Advanced Queues and Streams: A Definition in Plain English

Read the rest of this entry »

Oracle Advanced Replication: A Definition in Plain English

Read the rest of this entry »

Comment by Bob on Manually creating a Logical Change Record (LCR)

That was excellent!

I was having a little trouble when I was setting p_table_owner to a schema other than my own (I even have DBA and the select on all_tab_columns was successful).

Statement:

v_lcr.set_value(‘new’, ‘first_name’…

was throwing that ‘first_name’ did not exist in the LCR.

Once I copied the table to my own schema, works great!

Good for now – exactly what I needed – trying to develop the DML_Handlers before Streams is up and running.

Click to continue reading “Comment by Bob on Manually creating a Logical Change Record (LCR)”

Read the rest of this entry »

Comment by Bob on Manually creating a Logical Change Record (LCR)

That was excellent!

I was having a little trouble when I was setting p_table_owner to a schema other than my own (I even have DBA and the select on all_tab_columns was successful).

Statement:

v_lcr.set_value(‘new’, ‘first_name’…

was throwing that ‘first_name’ did not exist in the LCR.

Once I copied the table to my own schema, works great!

Good for now – exactly what I needed – trying to develop the DML_Handlers before Streams is up and running.

Click to continue reading “Comment by Bob on Manually creating a Logical Change Record (LCR)”

Read the rest of this entry »

Comment by Udgith Mankad on Oracle Streams Configuration: Change Data Capture

Hi Lewis,

I have created emp_dml_handler using the procedure here. I have also run the streams_hc_11GR1.sql available on metalink to make sure that there are no errors in my streams configuration.

I am simply trying to insert data into employee table and expect employee_audit and streams_monitor get updated based on the emp_dml_handler procedure.

Please let me know how to enable trace/debugging so that I know whether the DML handler is invoked correctly.

Click to continue reading “Comment by Udgith Mankad on Oracle Streams Configuration: Change Data Capture”

Read the rest of this entry »

Comment by zhaque on Oracle Streams Configuration: Change Data Capture

To stream two or more tables, do I need to add

add_table_rules both in capture and apply processes?

thanks,

!***! Entry Link: Oracle Streams Configuration: Change Data Capture!***!

Click to continue reading “Comment by zhaque on Oracle Streams Configuration: Change Data Capture”

Read the rest of this entry »

PL/XML – XML Based Scripting for PL/SQL

Read the rest of this entry »

XML in the Database: A Brief Overview

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 3

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 2

Read the rest of this entry »

Oracle Objects, Types and Collections: Part 1

Read the rest of this entry »

Oracle Security: A Definition in Plain English, Part 3

Read the rest of this entry »

Oracle Security: A Definition in Plain English, Part 2

Read the rest of this entry »

Eight Steps on the Collaborative Way

Read the rest of this entry »

Advanced Bash-Scripting Guide – Thought of the day, April 1, 2005

Read the rest of this entry »