Hi,
I am using LLBLGenPro 2.5 with the latest version of the runtime libraries, Oracle 10gR2 / ODP.NET 10g and the SelfServicing templates for .NET 2.0.
-
If a stored procedure parameter (or stored function return value) is of type "boolean", the Designer maps it to System.Byte.
-
Code generation is successful, but stored procedure invocation using the ActionProcedures class fails with an Oracle exception.
Example 1:
create or replace function test_func (x in integer) return boolean
is
begin
return x > 0;
end test_func;
/
show errors
Invocation of test_func yields the error:
ORA-06550: line 1, column 15:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Example 2:
create or replace procedure test_proc (x in integer, b out boolean)
is
begin
b := x > 0;
end test_proc;
/
show errors
Invocation of test_proc yields the error:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TEST_PROC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
The same problem very probably exists for the ODP.NET 9.2 driver and the MS Oracle driver, too.
A fix would be much appreciated!
Thanks and best regards,
Christoph