Why are you trying not to put column names in the select statement? The code will be open to errors this way (what will happen if somebody adds a column?) and may perform slower (consider the chained rows, if you select a column you do not need which is on the chained part of a row you are doing extra unnecessary reads).
I did not try how to correct the issue without putting the column names but using column names is the first thing to do i think.
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of manoj.gurnani@(protected) Sent: Monday, September 12, 2005 3:17 PM To: Oracle-L@(protected) Subject: Invoker rights procedure
Hi,
I've invoker rights procedure which is compiled in schema A.
The procedure runs from schema B which has execute privilege on B.
The schema A has table A and schema B has a view with same name as table A and with all columns of table A
Except last column of table A(say ctry_cd).
The procedure executes with an error in schema B at the following cursor :
Note : all col_name in cursor are present in view including i/p param type name .
Also column ctry_cd is not used in the procedure.
How can I change this procedure to resolve this error w/o including col names in select stmt of cursor.
Regards
Manoj
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit Us at http://www.polaris.co.in
Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.
This message and the files attached to it are under the privacy liability in accordance with the Banking Law and confidential to the use of the individual or entity to whom they are addressed. This message cannot be copied, disclosed or sold monetary consideration for any purpose. If you are not the intended recipient of this message, you should not copy, distribute, disclose or forward the information that exists in the content and in the attachments of this message; please notify the sender immediately and delete all copies of this message. Our Bank does not warrant the accuracy, integrity and currency of the information transmitted with this message. This message has been detected for all known computer viruses thence our Bank is not liable for the occurrence of any system corruption caused by this message <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft -com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http: //www.w3.org/TR/REC-html40">
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size: 12.0pt;font-family:Arial;color:blue'>Why are you trying not to put column names in the select statement? The code will be open to errors this way (what will happen if somebody adds a column?) and may perform slower (consider the chained rows, if you select a column you do not need which is on the chained part of a row you are doing extra unnecessary reads).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size: 12.0pt;font-family:Arial;color:blue'>I did not try how to correct the issue without putting the column names but using column names is the first thing to do i think.<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'> I’ve invoker rights procedure which is compiled in schema A.</span></font ><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>The procedure runs from schema B which has execute privilege on B.</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>The schema A has table A and schema B has a view with same name as table A and with all columns of table A</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>Except last column of table A(say ctry_cd).</span></font><span lang=EN-US><o:p></o:p></span ></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>The procedure executes with an error in schema B at the following cursor :</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>Note : all col_name in cursor are present in view including i/p param type name .</span>< /font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>Also column ctry_cd is not used in the procedure.</span></font><span lang=EN-US><o:p></o:p> </span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"> <span lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>How can I change this procedure to resolve this error w/o including col names in select stmt of cursor.</span></font><span lang=EN-US><o:p></o:p></span></p>
</html> <table><tr><td bgcolor=#ffffff><font color=#000000>This e-Mail may contain proprietary and confidential information and is sent for the intended recipient (s) only. <br> If by an addressing or transmission error this mail has been misdirected to you , you are requested to delete this mail immediately.<br> You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification,<br> distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.<br> <br> Visit Us at http://www.polaris.co.in<br> </font></td></tr></table> <table><tr><td bgcolor=#ffffff><font color=#000000><br> <br> Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.<br> </font></td></tr></table> <table><tr><td bgcolor=#ffffff><font color=#000000>This message and the files attached to it are under the privacy liability in accordance with the Banking Law and confidential to the use of the individual or entity to whom they are addressed. This message cannot be copied, disclosed or sold monetary consideration for any purpose. If you are not the intended recipient of this message, you should not copy, distribute, disclose or forward the information that exists in the content and in the attachments of this message; please notify the sender immediately and delete all copies of this message. Our Bank does not warrant the accuracy, integrity and currency of the information transmitted with this message. This message has been detected for all known computer viruses thence our Bank is not liable for the occurrence of any system corruption caused by this message<br> </font></td></tr></table>
