CheGuevara Posted February 21, 2012 Report Share Posted February 21, 2012 output format baledu... e statement execute chey, issue ento telustadi: [color=#282828][font=helvetica, arial, sans-serif]select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'[/font][/color] Link to comment Share on other sites More sharing options...
kiraaaak Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CBZ' timestamp='1329855288' post='1301437244'] atta double click sette ala cursor aadaki potale ba...toad nenu ekkuva use cheyan ba...so emanna miss avutunanna req pampa ba... [/quote] mail pamppu ba .. offline lo unna nenu Link to comment Share on other sites More sharing options...
galigannarao Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CheGuevara' timestamp='1329855337' post='1301437248'] output format baledu... e statement execute chey, issue ento telustadi: [color=#282828][font=helvetica, arial, sans-serif]select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'[/font][/color] [/quote]kummi vadialvuga Link to comment Share on other sites More sharing options...
CheGuevara Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='galigannarao' timestamp='1329855419' post='1301437256'] kummi vadialvuga [/quote] ante enti? Link to comment Share on other sites More sharing options...
peru_edaite_enti Posted February 21, 2012 Author Report Share Posted February 21, 2012 [quote name='CheGuevara' timestamp='1329855337' post='1301437248'] output format baledu... e statement execute chey, issue ento telustadi: [color=#282828][font=helvetica, arial, sans-serif]select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'[/font][/color] [/quote] atta sette no errors ani vottundi.... SQL> select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'; no rows selected Link to comment Share on other sites More sharing options...
galigannarao Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CheGuevara' timestamp='1329855647' post='1301437275'] ante enti? [/quote] goodd post ani sebutunna bangaru Link to comment Share on other sites More sharing options...
CheGuevara Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='galigannarao' timestamp='1329855673' post='1301437279'] goodd post ani sebutunna bangaru [/quote] inka nenu vesindi banda boothemo anukunna Link to comment Share on other sites More sharing options...
Gachibowli_Diwakar Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CBZ' timestamp='1329855669' post='1301437278'] atta sette no errors ani vottundi.... SQL> select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'; no rows selected [/quote]ignore chesey ba .. em ORA errors lekapothe aah code ichina vaadini verify cheskomanu .. expected result ochindha ledha atu side ani Link to comment Share on other sites More sharing options...
galigannarao Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='Silence..Please' timestamp='1329856181' post='1301437319'] ignore chesey ba .. em ORA errors lekapothe aah code ichina vaadini verify cheskomanu .. expected result ochindha ledha atu side ani [/quote]ehe warnings unte maku ayte packages outputs ivvavu. so they have to run 100% without errors Link to comment Share on other sites More sharing options...
Gachibowli_Diwakar Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='galigannarao' timestamp='1329856245' post='1301437324'] ehe warnings unte maku ayte packages outputs ivvavu. so they have to run 100% without errors [/quote]nenu aithe ignore chesestha .. em errors kanipinchakapothe .. execute chesinapudu screen meedha executed with errors ani kanipinchina kuda Link to comment Share on other sites More sharing options...
CheGuevara Posted February 21, 2012 Report Share Posted February 21, 2012 first see whether you have the permissions for the package , then run the below script: CREATE OR REPLACE PACKAGE BODY SMT_UTIL IS PROCEDURE k(p_table_name IN VARCHAR2, p_owner IN VARCHAR2 DEFAULT 'some_schema_name')IS v_exist VARCHAR2(1); v_sql VARCHAR2(1000); no_privs EXCEPTION; PRAGMA EXCEPTION_INIT(no_privs, -20001); BEGIN SELECT 'x' INTO v_exist FROM SMT_truncate_t WHERE owner = UPPER(NVL(p_owner,USER)) AND table_name = UPPER(p_table_name); v_sql := 'truncate table '||NVL(p_owner,USER)||'.'||p_table_name||''; EXECUTE IMMEDIATE v_sql; INSERT INTO SMT_util_log_t(owner, object_name, action, performed_on, performed_by, error_code) VALUES (NVL(p_owner,USER), p_table_name, 'TRUNCATE', SYSDATE, USER, 0); INSERT INTO SMT_TRUNCATE_LOG_T(owner, table_name, truncated_by, truncated_on, success) VALUES (NVL(p_owner,USER), p_table_name, USER, SYSDATE, Y); COMMIT; dbms_output.put_line('Table truncated successfully'); EXCEPTION WHEN NO_DATA_FOUND THEN INSERT INTO SMT_util_log_t(owner, object_name, action, performed_on, performed_by, error_code) VALUES (NVL(p_owner,USER), p_table_name, 'TRUNCATE', SYSDATE, USER, -20001); INSERT INTO SMT_TRUNCATE_LOG_T(owner, table_name, truncated_by, truncated_on, success) VALUES (NVL(p_owner,USER), p_table_name, USER, SYSDATE, N); COMMIT; RAISE_APPLICATION_ERROR(-20001, 'No privileges to truncate table '||NVL(p_owner,USER)||'.'||p_table_name); END k; END SMT_util; it works if you have the permission for that package that has this package body. Link to comment Share on other sites More sharing options...
katharnak Posted February 21, 2012 Report Share Posted February 21, 2012 ayyo entha kashtam vache cbz ki Link to comment Share on other sites More sharing options...
peru_edaite_enti Posted February 21, 2012 Author Report Share Posted February 21, 2012 [quote name='Silence..Please' timestamp='1329856181' post='1301437319'] ignore chesey ba .. em ORA errors lekapothe aah code ichina vaadini verify cheskomanu .. expected result ochindha ledha atu side ani [/quote] Adi nanne develop cheyamanar ba....ade ga bada.... [quote name='CheGuevara' timestamp='1329856906' post='1301437370'] first see whether you have the permissions for the package [/quote] nenu sys user to chestunna ba, so no issues with permission... Link to comment Share on other sites More sharing options...
Recommended Posts