tracker issue : CF-4113978

Problem Description: calling Stored Procedure was expecting StatusCode to be returned to check id proc executed correctly but it is not.

Steps to Reproduce:-- Table creation

create table Test
( id int, 
name varchar2(20)
);

-- Data insertion
insert into Test values(1, 'SomeText', 'SomeText', 23432.45, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 34.34, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(2, 'SomeText', 'SomeText', 324.23, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 56.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(3, 'SomeText', 'SomeText', 23232.2, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 78.6, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(4, 'SomeText', 'SomeText', 7665.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 789.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText');


--create stored procedure
create or replace procedure spTest (idd in number, name out varchar2) as 
Begin
SELECT name FROM Test where id = idd;
End;

--Calling Stored ptocedure
        spService = new storedproc();
        //set attributes using implicit setters
        spService.setProcedure("spTest");
        spService.returncode=true;
        //add procparams using addParam
        spService.addParam(cfsqltype="CF_SQL_DECIMAL", type="IN", value="2");
        spService.addParam(cfsqltype="CF_SQL_VARCHAR", type="OUT", value="name");

        //execute the stored procedure
        result = spService.execute();
        //getprocOutVariables() returns any OUT or INOUT varibles added using addParams()
        name = result.getProcOutVariables().name;

        WriteDump(result.getPrefix());
// only ExecutionTime in dump expectin StatusCode


Actual Result: only ExecutionTime returnedin in result.getPrefix() structure

Expected Result: FROM ADOBE SITE: " Note: If you specify a result attribute for a stored procedure, then calling getPrefix() returns, executionTime,statusCode,cached . If you do not specify a result attribute, getPrefix() returns only executionTime and statusCode."

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4113978

External Customer Info:
External Company:  
External Customer Name: Matthew Parks
External Customer Email:  
External Test Config: My Hardware and Environment details:Window 2012 R2 running CF11 update 7

Attachments:

Comments: