Hi,
I have cursor with a complex inline query, used inside the procedure. when the complile and excute the procedure its working fine in oracle 9i Database.
When i try to run this in the oracle 8i databse, i am getting an error code as pls:00103 where ever i use the inline query.
I would like to know how do we use the inline query in the oracle 8i databse.
here is my query :
CURSOR cur_prod_detail (owne VARCHAR2, prod VARCHAR2, iss VARCHAR2) IS
SELECT OWNER_ID,
PRODUCT_ID,
ISSUE,
'*' E_STATUS,
TAG_ALONG_ID_1,
TAG_ALONG_DATA_1,
TAG_ALONG_ID_2,
TAG_ALONG_DATA_2,
TAG_ALONG_ID_3,
TAG_ALONG_DATA_3,
SET_FLAG,
SET_PRICE_FLAG,
NVL((SELECT DISTINCT 'Y'
FROM PRODUCT_SET PS
WHERE PS.COMPONENT_OWNER_ID LIKE OWNER_ID
AND PS.COMPONENT_PRODUCT_ID LIKE PRODUCT_ID
AND PS.COMPONENT_MEDIA_TYPE LIKE line_media),'N') AS COMPONENT_FLAG
FROM PRODUCT
WHERE OWNER_ID LIKE owne
AND PRODUCT_ID LIKE prod
AND ISSUE LIKE iss
AND PRODUCT_STATUS IN ('A','P') ;
When i run just the query its giving an error as ORA-00936: missing expression
Start Free Trial
