[sqr-users] dbms_mview.refresh - run procedure in SQR?

["Bob Stone" <bstone@fastenal.com>]

Hi there.

Question on how to use the DBMS_MVIEW.REFRESH procedure in SQR.  I cannot seem 
to get this to work.

When running other procedures in SQR, we usually do the following : 
begin-SELECT 
FASTENAL_OM.FAS_GET_OUTSIDE_SALES_EMPLID( $cust_in, $date_in ) &emplid
  let $emplid_back = &emplid
FROM DUAL
end-select

but when I do that with the DBMS_MVIEW.REFRESH I get the following erro : 
(SQR 5528) ORACLE OPARSE error -904 in cursor 2:
   ORA-00904: invalid column name
SQL:  select DBMS_MVIEW.REFRESH('PS_FAS_AR_AD_CU_MV','c')  from dual 
Error at:  REFRESH('PS_FAS_AR_AD_CU_MV','c')

Error on line 139:
   (SQR 3716) Error in SQL statement.

Anybody have any idea how to run this procedure in an SQR?  any help would be 
greatly appreciated.

Thanks

Bob Stone  
Fastenal PS AP Developer
(507) 453-8514


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users