You can not select from a local view/cursor/table and an Oracle table in the same select statement.
>Hi All,
>
>I am wondering if it is possible to use a referance to a cursor in a 2nd SQL statement. In the following 'WRK_RTG' is a cursor that was created with a previous SQL statement.
>
>SELECT WRK_RTG.ORD_NO,
> LABOR_CHRGS.RELS_RTG_NO,
> LABOR_CHRGS.SEQ_NO,
> SUM(DECODE('MACH', LABOR_CHRGS.LABOR_RATE_CD_TYPE, LABOR_CHRGS.HRS, 0)) AS TOT_MACH_HRS,
> SUM(DECODE('RUN', LABOR_CHRGS.LABOR_RATE_CD_TYPE, LABOR_CHRGS.HRS, 0)) AS TOT_RUN_HRS,
> SUM(DECODE('SETUP', LABOR_CHRGS.LABOR_RATE_CD_TYPE, LABOR_CHRGS.HRS, 0)) AS TOT_SETUP_HRS
>FROM
> PROD.LABOR_CHRGS LABOR_CHRGS,
> WRK_RTG
>WHERE
> PROD.LABOR_CHRGS.RELS_RTG_NO = WRK_RTG.RELS_RTG_NO
>GROUP BY
> WRK_RTG.ORD_NO,
> PROD.LABOR_CHRGS.RELS_RTG_NO,
> PROD.LABOR_CHRGS.SEQ_NO
>ORDER BY
> WRK_RTG.ORD_NO,
> PROD.LABOR_CHRGS.RELS_RTG_NO,
> PROD.LABOR_CHRGS.SEQ_NO
>
>If I omit any referance to the cursor, all is ok. But when I put the cursor referance in, it doesn't work. I am using an ORACLE server
>
>TIA
>Mike
Mark McCasland
Midlothian, TX USA