Pl/sql Ppl....need Help

[peru_edaite_enti]

[quote name='galigannarao' timestamp='1329854677' post='1301437186']
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.
[/quote]

toad lo chesi aa error paina post esa ga...

[kiraaaak]

ante oracle database lo ... x schema lo undi .. ippud adi Y schema lo run cheyadaniki try chestunavaa ba .. correct me .. nenu package create chestuna nee code tho cheptha undu

[peru_edaite_enti]

[quote name='kiraaaak' timestamp='1329854755' post='1301437200']
ante oracle database lo ... x schema lo undi .. ippud adi Y schema lo run cheyadaniki try chestunavaa ba .. correct me .. nenu package create chestuna nee code tho cheptha undu
[/quote]

no same schema (ops$oracle) from DB A to same schema name in DB B

[Bondu_Babu]

[quote name='CBZ' timestamp='1329854074' post='1301437110']
neeku raada???
[/quote]
pl/sql lo manam nill..........

[galigannarao]

END SMT_util;

statementla SMT_util undiga adi create package body daggara specify chesina danto match avvalemo ga. syntax marsipoya Oracle touch chesi 6 months ayyindi

[peru_edaite_enti]

[quote name='Bondu_Babu' timestamp='1329854908' post='1301437209']
pl/sql lo manam nill..........
[/quote]

nenu bhi same baa....nerchukovali....edanna manchi linklu etuku...iddaram kalisi nerchukundam

[Gachibowli_Diwakar]

nenaithe ignore sesesthunta em ORA- errors kanipinchakapothe

[kiraaaak]

itla kadu kani nuvvu naa gmail ki .. deeni sangathi chudam

[Bondu_Babu]

[quote name='CBZ' timestamp='1329854961' post='1301437216']
nenu bhi same baa....nerchukovali....edanna manchi linklu etuku...iddaram kalisi nerchukundam
[/quote]
vakay chustha.......

[peru_edaite_enti]

[quote name='galigannarao' timestamp='1329854956' post='1301437215']
END SMT_util;

statementla SMT_util undiga adi create package body daggara specify chesina danto match avvalemo ga. syntax marsipoya Oracle touch chesi 6 months ayyindi
[/quote]

ya body ki spec ki same undi, ( util ni UTIL chesi exec chesina, same errror)

[galigannarao]

[quote name='CBZ' timestamp='1329855084' post='1301437225']
ya body ki spec ki same undi, ( util ni UTIL chesi exec chesina, same errror)
[/quote]
ippudu aa warningni double click cheste cursor will be pointing to a place in the query. ala emayina ayyinda.

[kiraaaak]

pm chesna naa id ... ping chey

[peru_edaite_enti]

[quote name='galigannarao' timestamp='1329855148' post='1301437232']
ippudu aa warningni double click cheste cursor will be pointing to a place in the query. ala emayina ayyinda.
[/quote]

atta double click sette ala cursor aadaki potale ba...toad nenu ekkuva use cheyan ba...so emanna miss avutunanna
[quote name='kiraaaak' timestamp='1329855161' post='1301437233']
pm chesna naa id ... ping chey
[/quote]

req pampa ba...

[CheGuevara]

see this:

select * from SYS.USER_ERRORS where NAME = 'SMT_UTIL' and type = 'PACKAGE BODY'

OUTPUT:


SMT_UTIL PACKAGE BODY 1 6 1 "PLS-00103: Encountered the symbol "V_EXIST" when expecting one of the following:

; is with authid as cluster order using external
deterministic parallel_enable pipelined
The symbol ";" was substituted for "V_EXIST" to continue.
" ERROR 103
SMT_UTIL PACKAGE BODY 2 28 1 "PLS-00103: Encountered the symbol "ON" when expecting one of the following:

. ) , @
The symbol "ON" was ignored.
" ERROR 103
SMT_UTIL PACKAGE BODY 3 38 1 "PLS-00103: Encountered the symbol "01" when expecting one of the following:

) , * & | = - + < / > at in is mod remainder not rem => ..
<an exponent *)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || member SUBMULTISET_
The symbol "," was substituted for "01" to continue.
" ERROR 103
SMT_UTIL PACKAGE BODY 4 41 1 "PLS-00103: Encountered the symbol "ON" when expecting one of the following:

. ) , @
The symbol "ON" was ignored.
" ERROR 103
SMT_UTIL PACKAGE BODY 5 45 1 "PLS-00103: Encountered the symbol "OWNER" when expecting one of the following:

. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent *)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ as between from using ||
multiset member SUBMULTISET_
The symbol "." was substituted for "OWNER" to continue.
" ERROR 103
SMT_UTIL PACKAGE BODY 6 49 1 PLS-00103: Encountered the symbol "END" ERROR 103

[kiraaaak]

ba nuvvu spec lo procedure lo IN prameters inka Body lo IN parameters same order and same undali adi undo ledo chudu ...
next nee dynamic sql rasnav kada adi build ainaka em vastundo chepu ..