Pl/sql Ppl....need Help

[peru_edaite_enti]

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??

[peru_edaite_enti]

endi evadu leda pl/sql vochinodu...

[ToughGuy]

help

help


help

help

help

help

help

help

help

help

[Bondu_Babu]

helpppppp

[peru_edaite_enti]

[quote name='Bondu_Babu' timestamp='1329853961' post='1301437102']
helpppppp
[/quote]

neeku raada???

[Spartan]

[quote name='CBZ' timestamp='1329854074' post='1301437110']
neeku raada???
[/quote]

[kiraaaak]

naku vachu chustuna ba .. undu .. TRUNCATE anedi keyword kada .. change chey okasari

[peru_edaite_enti]

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

[kiraaaak]

endhuloo rastunav code .. error ekada vastundi .. compiling lo na ... oka sari F9 kotti error ento chepu ba .. TOAD lo na

[kiraaaak]

inko db enti ... em database old di ..ippudu use chesedi em data base

[k2s]

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

[peru_edaite_enti]

[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

[galigannarao]

vachasaa [img]http://gifsoup.com/view3/3441816/manamahesh-o.gif[/img]

[peru_edaite_enti]

[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

[galigannarao]

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