sententia
Home    Blog

Blog - Tech / Database / Oracle

      
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.

May 05 at 1:47pm | 0 comments
I had to load Oracle full client on my server to build the datasources.

 
clip in thread hair wraps half up half down with bangs wig hair extensions uk how to style kinky curly hair best curly hair on aliexpress 2017 hair extensions kinky crochet hair uk senegalese twist hairstyles hair extensions uk hairstyles with extensions for black hair wholesale hair extensions human hair extensions ecotools hair brush dark grey hair extensions uk hair wigs