Passing Boolean value to Oracle Stored Procedure

dataservices job design
1

I am trying to call oracle stored procedure in query transform of data flow. Boolean Value (TRUE/FALSE) needs to be send as one parameter for this stored procedure. Since data services does not suport boolean data type, i could not pass boolean value to this stored procedure.

It can be done by creating new stored procedure with boolean int data type which in turn calls that existing stored procedure. Then i can use use new stored procedure which accepts 1/0 for the boolean paramter.

But i dont want to use the above option becuase there are already lot of packages/SP’s are available , its tough to maintain by creating stored procedures for some data services job purpose.

So please provide if there is any work around to pass a boolean value of TRUE/FALSE to oracle stored procedure from data services job.

Its would be great if someone responds ASAP. I need it urgently to implement it in my jobs, Users are waiting for the reports.

saraswathi1982 (BOB member since 2012-09-10)

2

If you were to make the call to the stored procedure using the sql() function I think you can pass the Boolean but as a string.

Sql(‘datastore’, ‘exec procname(TRUE)’);

eganjp :us: (BOB member since 2007-09-12)