Re: stored procedure, cursor problems

Steve Walterhouse <microcon_at_magicnet.net> ÚÁÐÉÓÁÎÏ × ÓÔÁÔØÀ <344BF7B4.639D_at_magicnet.net>...
> Here is a simple procedure definition with a cursor declaration:
>
> create or replace procedure schproc is
> CURSOR c1 IS SELECT DMD_PROJ_ONLY, DMD_PROJECT, SUP_PART, DMD_ORD_NBR,
> SUP_ORD_NBR, DMD_FLP_NBR FROM WDS01.SOD_TABLE SOD, WDS01.CSD_TABLE CSD
> WHERE SOD.SO_NBR = CSD.DMD_ORD_NBR GROUP BY CSD.DMD_PROJ_ONLY,
> CSD.DMD_PROJECT, CSD.SUP_PART, CSD.DMD_ORD_NBR, CSD.SUP_ORD_NBR,
> CSD.DMD_FLP_NBR HAVING CSD.SUP_ORD_NBR>' ';
> BEGIN
> OPEN c1;
> CLOSE c1;
> END schproc;
> /
 

> Why these errors. It is not recognizing wds01.sod_table as a table.
> WDS01 is a valid oracle user that owns table sod_table.
> The oracle user that I'm connected as has select privilege on
> wds01.sod_table.
> ******///////
>

Use SYNONYM for wds01.sod_table

Dmitry, moprok_at_ropnet.ru Received on Wed Oct 22 1997 - 00:00:00 CDT