Salley.us Blog

All Dates From Last 24 Hours From Last Week From Last Month From Last 60 days

Creating a thin oracle Data Source for Cold Fusion

May 05 at 1:39pm | 0 comments

Syntax I used in CF Admin

Java classes needed to connect to Oracle for ColdFusion

May 05 at 1:47pm | 0 comments

I had to load Oracle full client on my server to build the datasources.

Create an MsAccess Oracle like DUAL table

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.

ORACLE/PLSQL: TEST A STRING FOR A NUMERIC VALUE

Jun 26 at 7:45am | 0 comments

ORA-00942: table or view does not exist for a procedure

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.

Find invalid objects in your databases

Jul 19 at 6:58am | 0 comments

Copy Sql Navigator Connections to a new pc

Aug 01 at 7:36am | 0 comments

How to pass host, port, SID/Service name to connect to a oracle database

Feb 25 at 1:49pm | 0 comments

How to find the privileges and roles granted to a user in Oracle

Feb 25 at 2:39pm | 0 comments