Recent content by JRob

Thanks. I had only posted the first few lines. My sql contained the complete merge as referenced in your reply. MERGE INTO plados.plados_dealer_info T USING (SELECT * FROM olnd.olnd_plados) A ON (T.dealerid = A.di_dealer_id) WHEN MATCHED THEN UPDATE SET T.dealername = A.di_dealer_name...

Should the select privilege given to the role be removed?

SELECT privilege has now been granted directly to USER A. SELECT was previously granted to the role, which I left as is. Merging select statement... MERGE INTO plados.plados_dealer_info T USING (SELECT * FROM olnd.olnd_plados) A ON (T.dealerid = A.di_dealer_id) WHEN MATCHED THEN UPDATE SET

I have verified that VIEWB has given select privilege to A. VIEWB - gives select to A TABLEA - has select, update, insert, delete to A I am able to select independently from view and/or table, but merge still returns 00942 error

Procedure A and Table A are located in Schema A. Procedure A performs a merge between View B of Schema B and Table A. Procedure A is giving a ORA-00942(table or view does not exist) for the following line ... USING (SELECT * FROM B.VIEWB) Is this a permissions issue? When opening the schema...

Thanks.

I'm trying to schedule a procedure to run Monday-Friday between a set time frame. How could I accomplish this?

I'm a newbie, trying to schedule a procedure to run Monday-Friday between a set time frame. Does a scheduling wizard exist to accomplish this?