Query scope within a table trigger in an Oracle database
Posted
by sisslack
on Stack Overflow
See other posts from Stack Overflow
or by sisslack
Published on 2010-04-16T22:46:34Z
Indexed on
2010/04/16
22:53 UTC
Read the original article
Hit count: 183
I'm been trying to write a table trigger the queries another table that is outside the schema where the trigger will reside. Is this possible? It seems like I have no problem querying tables in my schema but I get:
Error: ORA-00942: table or view does not exist
when trying trying to query tables outside my schema. The documentation seems to elude to this notion, but it's not 100% clear to me.
© Stack Overflow or respective owner