Oracle Function in JDBC Adapter

[Former Member]

Dear All

Can we execute an oracle fucntion using receiver jdbc adapter? if yes then what should be the structure

I have gone through following links but the soluiotn is not clear

Regards

Sourabh

[former_member229036]

Dear Sourabh;

did you find solution regarding calling and response data  with oracle function in jdbc receiver ?

anyone know how to call oracle function in using jdbc receiver

input - date   response output  --  row data matched date

Thank You in advance.

David

[Former Member]

Hi,

Easiest and best way is to create a stored procedure on oracle server and call that using JDBC receiver.

Check this blog

thanks...

Sukarna...

[baskar_gopalakrishnan2]

I think two possible ways. You might want to write stored procedure and inside your stored procedure call oracle function. The second option is as below. In access tag write your query with standard functions. placeholder is to pass values for the variable.

<StatementName>

<anyName action=u201D SQL_QUERYu201D | u201CSQL_DMLu201D>

<access>SQL-String with optional placeholder(s)</access>

<key>

  <placeholder1>value1</placeholder1>

  <placeholder2>value2<placeholder2>

</key>

 </anyName >  

  </StatementName>

Ex:

SELECT '03.12.2004:10:34:24' "Now",
       TO_CHAR(hiredate,'DD.MM.YYYY:HH24:MI:SS') "Hiredate",
       TO_DATE('03.12.2004:10:34:24','DD.MM.YYYY:HH24:MI:SS')
       - hiredate "Hired since [Days]"
  FROM emp;

where to_char is the oracle function.