PL/SQL (MOSC)

MOSC Banner

ora-904 when using line view in cursor.

edited Jul 22, 2013 12:21AM in PL/SQL (MOSC) 6 commentsAnswered
Hello,

I am able to compile this pl/sql that uses the following cursor with an inline view. I am even able to create view of the select statement with the inline view. The inline view also calls funtions that each

returns a value to the inline view.

However when I actually run the code I get an ora-904 error. If it matters I actually am running this in EBS 12.1.3.

Here is the cursor:

    Select
        --h.gl_id,
        a.doc_no,
        --h.seq_no,
        a.julian_period,
        a.cal_year, a.cal_month, a.cal_day,
        --h.doc_descr,
 --l.gl_dtl_id,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center