I looked in the MIVR log files after turning on the debug you suggested and found the SQL 904 error. Now I have to figure out what that means.

Thanks again.

If its an ORA-904 error

(invalid column name)...

try this

SELECT ROP_USER.SHE_VALIDATE_WORK_ORDER( $StoreID , $WorkOrderID ) AS WORKORDERID , CURRENTSTATUS , CALLEXISTSFLAG FROM DUAL;

Try naming the Pl/sql column with an AS

PL/SQL procedures and CRS scripting Database steps have issues in my experience. I think technically Procedures don't return a value on a select, hence maybe this is where the 904 error comes in

I have been able to retrieve a PL/SQL Function, as opposed to a Procedure from a

select statement from dual on a DB Read CRS step. There are limitations in Oracle with PL/SQL functions versus PL/SQL procedures, but Functions do return a value and can be called be selected from.

If you must use a Procedure are comfortable with Java create a custom class to retrieve the Oracle PL/SQL Procedure may be the way to go.

let me know how it goes

Blair

*Please rate all useful posts

Thanks Blair,

I changed the syntax to use an as, but now I get a 920 error.

Any idea on that error.

I am not comfortable with a custom class, but can a sql function return multiple return values?

Thanks

Not sure of the 920 error, I can speculate this is related to the Procedure Call in a select statement

A PL/SQL function can only return 1 Value, however you could write a seperate function for each value needed and treat them each as a column, not the most Database efficient but workable.

Keep me posted, I want to hear how it turns out

Blair

*Please rate all useful posts