Re: OAS 4.0 can't use

leirace_at_my-dejanews.com wrote:

> I download the patch for nt sp4
> and start all the process in OAS
> have config DAD
> log table is installed
> pl/sql toolkit is installed
>
> but when I install database browser ,it allways tell me
>
> cursor tablespace_cursor is select tablespace_name from dba_tablespaces;
> "sys.dba_tablespaces" is not declare
>
> I install a very simple pl/sql procedure in OAS 4.0
> It's can't run, It's run good at OWS 2.1

Is it possible the DAD uses a diferent user to logon that the DCD in OWS 2.1?
You do not have rights to see the sys.dba_tablespaces when your cursor is compiled.

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046