Its not a ODBC driver problem though it throws an exception saying "ODBC driver doesnot support this function" please find the solution given by Rob ...
I am trying to execute an insert statement in the compute node but it throws an exeception :ODBC Driver does not support this function. calling oracle stored procedure works perfect.