Last post Aug 07, 2012 01:59 AM by Ajay2707
Aug 06, 2012 12:30 PM|-_-|LINK
my sp in PL/SQL has 2 output variable, when i run the sp in SQL Development, it always returns the error about "invalid column index". how to fix it? or how to find out where the problem is encountered?
Aug 06, 2012 12:44 PM|ganesh.rane|LINK
Can you please post your PL/SQL code here.
One of the reason for this error is
You are attempting to use or access a column that is not in the select list.
Aug 07, 2012 01:59 AM|Ajay2707|LINK
This show that you are no value in your output variable. it's most likely because you are trying to get or set a value from a ResultSet, but the index you are using isn't within the range.
If you return cursor, then do this.
IS SELECT SYSDATE FROM DUAL;
If you return simple variable , then set default value.
To check properly, you run test window in PL/SQl developer tool.