Oracle connector to run an FN

Q&A
1

Hi everyone!

I'm in need of running a FN like the following one:

declare teste varchar2(255);
ret number;
BEGIN
ret := FN_GRMOVEST_NEGATIVO (100,505,0,21,100,72,3210,null,null,9999,2008,'9','141128','E',100,sysdate,'L',1,null,null,sysdate,'PA',null,null,6006712,1,teste,10.10,null,null);
end;

 

However, I keep getting error. Probably about that ';' in the code. Not sure. The error is the following:

Caused by: org.bonitasoft.engine.connector.ConnectorException: ocorreu um erro durante a formação do lote: ORA-06550: line 1, column 27:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

<p>
	&nbsp;&nbsp; := ; not null default character</p>

 

Any tip will be welcome.

Thanks again.

2

Hi Rafael, 

Following existing source code I believe the java.sql.Statement which is used does not allow to execute function or stored procedure. So I believe you ought to build a custom connector that would use something like the java.sql.CallableStatement. Maybe fork and make a pull request with your own code for such thing ?

3

Hi Renaud,

Thanks for your answer. :)

However, I just solved it...and as I thought, it was some detail: The ; in the lines were screwing the whole code. Removed them all. Everything started working. :)

Thanks for your answer anyway.

4

Hi Rafael,

Can you post a sample of the connector impl to call a function in an Oracle database?

Thanks in advance,
Jose.