Call stored procedure about robotframework-database-library HOT 5 CLOSED

Hi
Thank you for call_procedure method, very useful.

We use it often but face a problem of calling procedures with output parameters type FLOAT.

Parameters for the call : ${parameters} = ['9932218011857', u'Deactive', u'NUMBER', u'NUMBER', u'call procedure from RIDE']

And got FAIL :
DatabaseError: ORA-06550: line 1, column 63:
PLS-00103: Encountered the symbol ";" when expecting one of the following:

) , * & | = - + < / > at in is mod remainder not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ as between from overlaps using || multiset year
DAY_ member SUBMULTISET_
The symbol ")" was substituted for ";" to continue.

Doing call of procedure with same input parameters from PL/SQL Developer doesn't give any errors and works as expected.

Please recommend how to modify code to avoid such FAIL.

from robotframework-database-library.

Hi, Seems to me very complicated.

Try this:

import ast

    def call_procedure(self, name, parameters):
        '''
        call stored procedure with in and out parameters 
        @param name: name of procedure
        @param parameters: any set of parameters:
        - 25 # single parameter
        - [25, 'Text value'] # set of parameters
        '''
        cur = None
        try:
            cur = self._dbconnection.cursor()
            self.__callproc_sql(cur, name, parameters)
            allRows = cur.fetchall()
            self._dbconnection.commit()
            return allRows
        finally :
            if cur :
                self._dbconnection.rollback()

    def __callproc_sql(self, cur, procname, parameters):
        logger.debug("Executing : %s %s" % (procname, parameters))
        return cur.callproc(procname, ast.literal_eval(parameters))

from robotframework-database-library.

Call Stored Procedure keyword is not available in the master branch.

from robotframework-database-library.

@jerry57 Did you mean "now available"?

from robotframework-database-library.

yes, sorry about that typo :(

from robotframework-database-library.