hi may i know y am i getting this error
От | Penchalaiah P. |
---|---|
Тема | hi may i know y am i getting this error |
Дата | |
Msg-id | A70AE049E81A6A40879D5DC0AC8C38C9078D7304@venus.infics.com обсуждение исходный текст |
Ответы |
Re: hi may i know y am i getting this error
Re: hi may i know y am i getting this error |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Hi</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">When I am executing my function its giving error.. first time its running properly.. but when I am executingsecond time I am getting error</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">create or replace function irla_punching_medium_insert1(in_proj_code numeric,in_pt_code varchar,in_mon_absdate) returns varchar as'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">declare</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">l_p varchar;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">credit_amount numeric;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">debit_amount numeric;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">l_vr_no varchar;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">l_count integer;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">begin</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">select irla_code into l_p from npo_project_irla_code where npo_proj_code=$1 and pt_code=$2;</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">create table dummy_table without oids as </span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial">select side,irla_code,substr(type_charge,1,1)||substr(type_charge,2,1) || substr(type_charge,4,1) ||substr(type_charge,5,1)as type_charge,npo_code from irla_npo_pm_codes_master </span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">where type_charge=''(+-)CR'' or type_charge=''(+-)RC'' </span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">union all </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">select side,irla_code,substr(type_charge,1,1)||substr(type_charge,3,1)||substr(type_charge,4,1) || substr(type_charge,6,1)as type_charge,npo_code from irla_npo_pm_codes_master </span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">where type_charge=''(+-)CR'' or type_charge=''(+-)RC'' </span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">union all select side,irla_code,type_charge,npo_code from irla_npo_pm_codes_master where type_charge=''(+)C'' or type_charge=''(+)R'' ;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><b><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">update dummy_table set irla_code=l_p where irla_code=''P'';</span></font></b><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">create table amount_table without oids as select dt.side,dt.irla_code,sum(npoaa.amount) as amount,dt.type_chargefrom npo_abs_amount npoaa,dummy_table dt where dt.side=npoaa.side and dt.npo_code=npoaa.npo_code </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> and extract(month from to_date(npoaa.mon_abs,''yyyy-mm-dd''))||''/''|| extract(year from to_date(npoaa.mon_abs,''yyyy-mm-dd''))</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">=extract(month from to_date($1,''yyyy-mm-dd''))||''/''|| extract(year from to_date($1,''yyyy-mm-dd'')) and npoaa.proj_code=$1 and npoaa.pt_code= $2 group by dt.irla_code ,dt.type_charge,dt.side ;</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">drop table dummy_table;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">select cast(substr(max(vr_no),1,2) || cast(substr(max(vr_no),3,1) as integer)+1 as varchar) into l_vr_nofrom irla_punchingmedium_top_amt ;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">select sum(amount) into credit_amount from amount_table where side=''C'';</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">select sum(amount) into debit_amount from amount_table where side=''D'';</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">insert into irla_punchingmedium_top_amt (vr_no,credit_tot_amt,class_of_vr,mon_abs,proj_code,pt_code,debit_tot_amt)values</span></font><pclass="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">(l_vr_no,credit_amount,1,$3,$1,$2,debit_amount);</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">insert into irla_punchingmedium_amt (amount,codehead,type_of_charge,vr_no) select amount,irla_code,type_charge,(selectl_vr_no) from amount_table;</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">raise notice''%'', l_vr_no;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">drop table amount_table;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> raise notice ''%2'', l_count;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">return ''inserted'';</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">end;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">'language'plpgsql';</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ERROR: relation with OID 75275 does not exist</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial">CONTEXT: SQL statement "update dummy_table set irla_code= $1 where irla_code='P'"</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">PL/pgSQL function "irla_punching_medium_insert1" line 19 at SQL statement</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="navy"face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">Thanks & Regards</span></font><font color="navy"><span style="color:navy"></span></font></b><pclass="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="navy"face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">Penchal reddy </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> Software Engineer </span></font><font color="navy"><span style="color:navy"></span></font></b><pclass="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="navy"face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">Infinite Computer Solutions </span></font></b><b><font color="red" face="Tahoma" size="1"><spanstyle="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> Exciting Times…Infinite Possibilities... </span></font><font color="navy"><span style="color:navy"></span></font></b><pclass="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="navy"face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">SEI-CMMI level 5 </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">| </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black; font-weight:bold">ISO 9001:2000</span></font><font color="navy"><span style="color:navy"></span></font></b><p class="MsoNormal"style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">IT SERVICES </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> BPO </span></font><fontcolor="navy"><span style="color:navy"></span></font></b><p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><fontcolor="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">Telecom </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black;font-weight:bold">Finance</span></font></b><b><font color="red" face="Tahoma"size="1"><span style="font-size: 8.0pt;font-family:Tahoma;color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><spanstyle="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold"> </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black; font-weight:bold">Healthcare </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:red; font-weight:bold">| </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black;font-weight:bold">Manufacturing</span></font></b><b><font color="red"face="Tahoma" size="1"><span style="font-size: 8.0pt;font-family:Tahoma;color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><spanstyle="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold"> </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black; font-weight:bold">Energy & Utilities </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black;font-weight:bold">Retail& Distribution </span></font></b><b><fontcolor="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:red;font-weight:bold">|</span></font></b><b><fontcolor="navy" face="Tahoma"size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold"> </span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black; font-weight:bold">Government </span></font><font color="navy"><spanstyle="color:navy"></span></font></b><p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><fontcolor="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:navy;font-weight:bold">Tel +91-80-5193-0000(Ext:503)</span></font></b><b><font color="red" face="Tahoma" size="1"><spanstyle="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> Fax +91-80-51930009 </span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold"> Cell No +91-9980012376</span></font></b><b><font color="red" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:red;font-weight:bold">|</span></font></b><b><font color="navy" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:navy; font-weight:bold">www.infics.com</span></font></b><b><font color="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:black; font-weight:bold"> </span></font><font color="navy"><span style="color:navy"></span></font></b><p class="MsoNormal"style="mso-margin-top-alt:auto;margin-bottom:5.0pt"><b><font color="gray" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:gray;font-weight:bold">Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ orits Customers and is intended for use only by the individual or entity to which it is addressed, and may contain informationthat is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipientor it appears that this mail has been forwarded to you without proper authority, you are notified that any use ordissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at</span></font></b><b><fontcolor="black" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:black;font-weight:bold"> </span></font></b><b><u><font color="gray" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma;color:gray; font-weight:bold">info.in@infics.com </span></font></u></b><b><font color="gray" face="Tahoma" size="1"><span style="font-size:8.0pt;font-family:Tahoma; color:gray;font-weight:bold">and delete this mail from your records.</span></font><font color="navy"><span style="color:navy"></span></font></b><pclass="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div><table><tr><td bgcolor="#ffffff"><font color="#000000">Information transmitted by this e-mailis proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individualor the entity to which it is addressed, and may contain information that is privileged, confidential or exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwardedto you without proper authority, you are notified that any use or dissemination of this information in any manneris strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email fromyour records.<br /></font></td></tr></table>
В списке pgsql-sql по дате отправления: