procedure – Vollett Information Management Consultancy

Use trigger to force use of sequence

By admin Posted on July 25, 2014 Posted in Oracle Tagged with oracle, pl/sql, procedure, sequence, sql, trigger

ORACLE PL/SQL procedure permissions

By admin Posted on June 23, 2014 Posted in Oracle Tagged with oracle, permissions, pl/sql, proc, procedure

Issue: Trying to issue an EXECUTE IMMEDIATE command from within a PL/SQL procedure and geting: ORA-01031: insufficient privileges while issuing an EXECUTE IMMEDIATE. The same EXECUTE IMMEDIATE command works from within an anonymous PL/SQL block. The procedure and the anonymous block …

ORACLE PL/SQL procedure permissions Read more »

Tag: procedure

Use trigger to force use of sequence

ORACLE PL/SQL procedure permissions