Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hello Ladies and Gents,

I've been trying to deploy a recursive query as a view in Oracle XE and Standard Edition, neither to much success.

The query is located in this question here:

with recursion_view(base, parent_id, child_id, qty) as (
   -- first step, get rows to start with
     parent_id base, 

  union all

  -- subsequent steps
    -- retain base value from previous level
    -- get information from current level
    -- accumulate sum 
    (previous_level.qty + current_level.qty) as qty 
    recursion_view previous_level,
    md_boms        current_level
    current_level.parent_id = previous_level.child_id
  base, parent_id, child_id, qty
order by 
  base, parent_id, child_id

The query itself works and returns results. However, when I try to create a view with that query, I receive errors.

I've posted two screenshots: and The first one with the ! and * is when I am using JDeveloper 11g, using the Database Navigator, right-click on View and select "New View". I receive the error when I click OK. I can indeed create the view through a sql script, but when I attempt to view the data, I receive the ORA_00600 error.

I've tried this on both my local machine for XE (version and on 11g Standard Edition ( via Amazon Web Services. The result is the same.

Does anyone know how to get around this?

share|improve this question
Not 5 minutes after I post this, I decide not to use JDev's graphical editor, and simply write SELECT * FROM BOMS_VIEW; And it works like a charm. I just can't use data tab to view the records in the editor. Wish I had known that 5 hours ago. – Will Lovett Jun 28 '13 at 21:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.