Oracle - function returning Boolean - java.lang.UnsupportedOperationException: Type PL/SQL is not supported

213 views
Skip to first unread message

mczajk

unread,
Oct 12, 2009, 9:43:49 AM10/12/09
to dbfit, mcz...@gmail.com
DBFit 20080822

Test page:
!|Execute Procedure|Test1|
|i|?|
|1|TRUE|

Function definition:
CREATE OR REPLACE FUNCTION test1(i IN NUMBER) RETURN BOOLEAN AS
BEGIN
RETURN TRUE;
END;

Test returns following exceptions:
Execute Procedure
--------------------------------------------------------------------------------

java.lang.NullPointerException
at dbfit.fixture.ExecuteProcedure.doTable(ExecuteProcedure.java:114)
at fitlibrary.traverse.AlienTraverseHandler.doTable
(AlienTraverseHandler.java:18)
at fitlibrary.traverse.workflow.DoTraverse.interpretWholeTable
(DoTraverse.java:98)
at fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:63)
at fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:39)
at fitlibrary.DoFixture.interpretTables(DoFixture.java:40)
at dbfit.DatabaseTest.interpretTables(DatabaseTest.java:24)
at fit.Fixture.doTables(Fixture.java:75)
at fit.FitServer.process(FitServer.java:76)
at fit.FitServer.run(FitServer.java:52)
at fit.FitServer.main(FitServer.java:43)
Test1
i
--------------------------------------------------------------------------------

java.lang.UnsupportedOperationException: Type PL/SQL is not supported
at dbfit.environment.OracleEnvironment.getJavaClass
(OracleEnvironment.java:247)
at dbfit.environment.OracleEnvironment.readIntoParams
(OracleEnvironment.java:198)
at dbfit.environment.OracleEnvironment.getAllProcedureParameters
(OracleEnvironment.java:161)
at dbfit.fixture.ExecuteProcedure.initParameters
(ExecuteProcedure.java:169)
at dbfit.fixture.ExecuteProcedure.executeStatementForEachRow
(ExecuteProcedure.java:154)
at dbfit.fixture.ExecuteProcedure.doRows(ExecuteProcedure.java:127)
at fit.Fixture.doTable(Fixture.java:162)
at dbfit.fixture.ExecuteProcedure.doTable(ExecuteProcedure.java:112)
at fitlibrary.traverse.AlienTraverseHandler.doTable
(AlienTraverseHandler.java:18)
at fitlibrary.traverse.workflow.DoTraverse.interpretWholeTable
(DoTraverse.java:98)
at fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:63)
at fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:39)
at fitlibrary.DoFixture.interpretTables(DoFixture.java:40)
at dbfit.DatabaseTest.interpretTables(DatabaseTest.java:24)
at fit.Fixture.doTables(Fixture.java:75)
at fit.FitServer.process(FitServer.java:76)
at fit.FitServer.run(FitServer.java:52)
at fit.FitServer.main(FitServer.java:43)
?
1 TRUE

Is the boolean type supported by DBFit?

Regards,
MC
Reply all
Reply to author
Forward
0 new messages