Oracle Application Express (MOSC)

MOSC Banner

page items as part of select for classic report

edited Sep 4, 2015 10:06AM in Oracle Application Express (MOSC) 2 commentsAnswered

I have a classic report using the following sql

SELECT SUBSCRIBER_NAME,

       CONTENTID

FROM VWINF_CONTENTSUBSCRIBERS

WHERE  contentid = :P15_XCONTENTID

UNION

SELECT "SUBSCRIBER_NAME",

       3<----------------------

FROM WINF_SUBSCRIBERS

WHERE SUBSCRIBER_NAME NOT IN (

SELECT SUBSCRIBER_NAME

FROM VWINF_CONTENTSUBSCRIBERS

WHERE CONTENTID = :P15_XCONTENTID AND SUBSCRIBED = 1)

This runs fine.

I want to replace 3 with ::P15_XCONTENTID it then fails

Is what I am doing 'Allowed'

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