Re: Snapshot Refresh Groups

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 05 Dec 1999 17:24:48 +0800
Message-ID: <384A2F60.1872@yahoo.com>

rspeaker_at_my-deja.com wrote:
>
> Hi,
>
> I have 3 snapshots that require refreshing at the same time, so I wanted
> to put them into a snapshot refresh group. But I'm having some problems
> with the syntax. First, I tried to follow the example in the Oracle 8
> Complete Reference book;
>
> execute DBMS_REFRESH.MAKE
> (name => 'ledger_group',
> list => 'local_ledger, local_ledger_totals',
> next_date => SysDate,
> interval => SysDate+7)
>
> Well, as soon as I type the first line and hit enter, I get:
> SQL> exec dbms_refresh.make
> begin dbms_refresh.make; end;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'MAKE'
> ORA-06550: line 1 column 7:
> PL/SQL: Statement ignored
>
> SQL>
>
> OK, so then I put the entire command into a shell script, all on one
> line, like this:
>
> execute DBMS_REFRESH.MAKE (name => 'ledger_group', list => local_ledger,
> local_ledger_totals', next_date => SysDate, interval => SysDate+7)
>
> this time, it appears to have a problem with the interval setting, as I
> get the following messages:
>
> SQL>@/tmp/rgmake
> begin dbms_refresh.make (name => 'ledger_group', list =>
> local_ledger, local_ledger_totals', next_date => SysDate,
> interval => SysDate+7); end;
>
> *
> ERROR at line 1:
> ORA-23319: parameter value "10-DEC-99" is not appropriate
> ORA-06512: at "SYS.DBMS_JOB", line 50
> ORA-06512: at "SYS.DBMS_JOB", line 120
> ORA-06512: at "SYS.DBMS_IREFRESH", line 92
> ORA-06512: at "SYS.DBMS_IREFRESH", line 152
> ORA-06512: at "SYS.DBMS_REFRESH", line 104
> ORA-06512: at "SYS.DBMS_REFRESH", line 78
> ORA-06512: at line 1
>
> SQL>
>
> I have my JOB_QUEUE_PROCESSES set to 2 and JOB_QUEUE_INTERVAL set to 120
> in the init.ora file. Can anybody shed any light on what is wrong with
> this?
>
> Thanks,
> Roy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Put it into a file, or use the SQL PLus separator (-)

eg

SQL> exec my_proc(param1, -

          param2, -
          etc );

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Dec 05 1999 - 03:24:48 CST