peru_edaite_enti Posted February 21, 2012 Report Share Posted February 21, 2012 Ee package body ni create cheste ila vostundi: Warning: Package Body created with compilation errors. SQL> show errors No errors. Conetent: CREATE OR REPLACE PACKAGE BODY "OPS$ORACLE"."SMT_UTIL" AS PROCEDURE TRUNCATE(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, -200 01); 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 TRUNCATE; END SMT_util; Ekkadanna sytax error vunda?? Link to comment Share on other sites More sharing options...
peru_edaite_enti Posted February 21, 2012 Author Report Share Posted February 21, 2012 endi evadu leda pl/sql vochinodu... Link to comment Share on other sites More sharing options...
ToughGuy Posted February 21, 2012 Report Share Posted February 21, 2012 help help help help help help help help help help Link to comment Share on other sites More sharing options...
Bondu_Babu Posted February 21, 2012 Report Share Posted February 21, 2012 helpppppp 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='Bondu_Babu' timestamp='1329853961' post='1301437102'] helpppppp [/quote] neeku raada??? Link to comment Share on other sites More sharing options...
Spartan Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CBZ' timestamp='1329854074' post='1301437110'] neeku raada??? [/quote] Link to comment Share on other sites More sharing options...
kiraaaak Posted February 21, 2012 Report Share Posted February 21, 2012 naku vachu chustuna ba .. undu .. TRUNCATE anedi keyword kada .. change chey okasari 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='kiraaaak' timestamp='1329854271' post='1301437130'] naku vachu chustuna ba .. undu .. TRUNCATE anedi keyword kada .. change chey okasari [/quote] ee script already inko database nundi lift chesi new db lo exec chestunte ila vostundi..so keyword aite inko db lo ela working? Link to comment Share on other sites More sharing options...
kiraaaak Posted February 21, 2012 Report Share Posted February 21, 2012 endhuloo rastunav code .. error ekada vastundi .. compiling lo na ... oka sari F9 kotti error ento chepu ba .. TOAD lo na Link to comment Share on other sites More sharing options...
kiraaaak Posted February 21, 2012 Report Share Posted February 21, 2012 inko db enti ... em database old di ..ippudu use chesedi em data base Link to comment Share on other sites More sharing options...
k2s Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CBZ' timestamp='1329852627' post='1301437004'] endi evadu leda pl/sql vochinodu... [/quote][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8641.jpg[/img] 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='kiraaaak' timestamp='1329854390' post='1301437149'] endhuloo rastunav code .. error ekada vastundi .. compiling lo na ... oka sari F9 kotti error ento chepu ba .. TOAD lo na [/quote] general ga direct sqlplus to db lo login aiyi script exec chesta...sare ani toad lo exec cheste ila vochindi: 10:55:56 Error: 'P_TABLE_NAME' is not a valid integer value, 10:57:47 Error: 'IN' is not a valid integer value Link to comment Share on other sites More sharing options...
galigannarao Posted February 21, 2012 Report Share Posted February 21, 2012 vachasaa [img]http://gifsoup.com/view3/3441816/manamahesh-o.gif[/img] 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='kiraaaak' timestamp='1329854432' post='1301437155'] inko db enti ... em database old di ..ippudu use chesedi em data base [/quote] say in x instance/database lo ee package already undi, so aa DDL lift chesi Y ane database lo create cheyadaniki try chestunna Link to comment Share on other sites More sharing options...
galigannarao Posted February 21, 2012 Report Share Posted February 21, 2012 [quote name='CBZ' timestamp='1329854536' post='1301437170'] say in x instance/database lo ee package already undi, so aa DDL lift chesi Y ane database lo create cheyadaniki try chestunna [/quote]command promptlo chustunnava baa. toad kani sql developer kani vadatled :think: oka vela unte sql developerlo open chesi warning meed double click cheyyu. naku ee query chuste ardam avvatledu. Link to comment Share on other sites More sharing options...
Recommended Posts