Pl/sql Ppl....need Help

[CheGuevara]

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]

[kiraaaak]

[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

[galigannarao]

[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

[CheGuevara]

[quote name='galigannarao' timestamp='1329855419' post='1301437256']
kummi vadialvuga
[/quote]

ante enti?

[peru_edaite_enti]

[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

[galigannarao]

[quote name='CheGuevara' timestamp='1329855647' post='1301437275']

ante enti?
[/quote]
goodd post ani sebutunna bangaru

[CheGuevara]

[quote name='galigannarao' timestamp='1329855673' post='1301437279']
goodd post ani sebutunna bangaru
[/quote]


inka nenu vesindi banda boothemo anukunna

[Gachibowli_Diwakar]

[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

[galigannarao]

[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

[Gachibowli_Diwakar]

[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

[CheGuevara]

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.

[katharnak]

ayyo entha kashtam vache cbz ki

[peru_edaite_enti]

[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...