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

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

Well, it seems someone in my company was able to point it out to me.  For those 
interested, you can call the stored procedure, but for whatever reason you need 
2 semi-colons, as shown below.

begin-sql
begin
  DBMS_MVIEW.REFRESH('PS_FAS_AR_AD_IN_MV','c') ;;
end;;
end-sql

...well, that mostly makes sense.  Pretty intuitive, if you think about it. 
...wait, no.  works tho.

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of Bob
Stone
Sent: Monday, October 31, 2005 11:37 AM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: [sqr-users] dbms_mview.refresh - run procedure in SQR?


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

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