New answers tagged oracle-10g
I see you are using a dbstart script to start your database. In your dbstart script, change the value of ORACLE_HOME_LISTENER: ORACLE_HOME_LISTNER=$ORACLE_HOME;
I think you might be able to get the results you want with: select j_title, k_title, l_title, sum(wrk_hr) from ( SELECT J.J_Title, K.K_Title, L.L_Title, L.Work_ID, SUM(CASE WHEN TRUNC(C.CHRG_DT) = TO_DATE('09/27/2013', 'mm/dd/yyyy') THEN C.WRK_HR END) AS WRK_HR FROM C, L, K, J WHERE J.Project_ID = 'ABC' AND K.Project_ID = J.Project_ID ...
This is indeed possible with stored procedures running with AUTHID DEFINER. Such SPs run with the authority of whoever created them. Please note that the creator must have explicit grants to the queried table; authorities acquired via roles will have no effect in a stored procedure.
As long as you have your database organized in such a way that there is an account that is the owner of the tables and other objects, and your application connects using a separate account you can do what you want. If you have tables and procedures organized in separate owners, you fist have to grant the required tables to the procedure owner (directly ...
You can get this info from DBA_LOCKS. select * from DBA_LOCKS where LOCK_TYPE = 'PL/SQL User Lock'; DBA_LOCKS has the SESSION_ID and the lock id.
It's realistically a bug in whatever version of 10g you're using that would appear to be fixed in whatever version of 11g you're seeing an error on both statements. I don't have a 10g database in front of me to test this. I would wager, through, that you'd get an error in both cases if you used the old-style join syntax rather than the SQL 99 syntax. ...
Top 50 recent answers are included