Invoker rights procedure

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Invoker rights procedure

Invoker rights procedure

2005-09-12 - By manoj.gurnani@(protected)

Reply: 1 2

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
:

Cursor(ip_param A.col_name%type)

Is

Select * from <table> A

Where col_name = ip_param;

Error

ORA-01007 (See ORA-01007.ora-code.com): variable not in select list

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

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">

<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>


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 :


 


Cursor(ip_param A.col_name
%type)


Is


Select * from <table>
A


Where col_name = ip_param;


 


Error


ORA-01007 (See ORA-01007.ora-code.com): variable not in
select list


 


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


 


 

 

</div>

</body>

</html>

<table><tr><td bgcolor=#ffffff>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 
</td></tr></table>