Home    Blog

Blog - Tech / Database / Oracle

Sep 18 at 1:57pm | 0 comments

Jun 18 at 8:06am | 0 comments

Jun 12 at 8:10am | 0 comments

Feb 25 at 2:39pm | 0 comments

Feb 25 at 1:49pm | 0 comments

Aug 01 at 7:36am | 0 comments

Jul 19 at 6:58am | 0 comments

Nov 20 at 2:56pm | 0 comments
A table in another schema that my user has select on (via a role) was not usable in an oracle procedure.  I kept getting these errors when I tried to compile
ORA-24344: success with compilation error
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
Bottom Line:  It appears that procedures don't respect roles and the grant needs to be applied directly to the user.

Jun 26 at 7:45am | 0 comments

Sep 18 at 10:59am | 0 comments
Had a need to replicate some logic used in Oracle into an Access db.  The oracle DUAL table is very handy.  I found this article on creating a hidden dual table.  It looked interesting but I didn't fully vet it.