Hi all,
I am calling a stored procedure in oracle. The procedure returns a "ref cursor" data type.
When calling with SQL Developer I have this result:
select bddoc_mgr.get_file_status_fme('w:\rwa005\energis\data\dwg\bp\geo','l144152-3.dwg') from dual
{<FILE_ID=1,S_FILE_STATUS=2,S_STATUS=4,N_VERSION=1000,L_USERID=IAA543 >,}When calling with SQLCreator I have this error:
Could not understand type information: type=116, size=8, scale=0, precision=0ORACLE Reader: Executing SQL Statement `select bddoc_mgr.get_file_status_fme('w:\rwa005\energis\data\dwg\bp\geo','l144152-3.dwg') from dual' to obtain features for feature type `QueryFactory_SQLExecute'Unable to define column number 1: error was `ORA-01024: invalid datatype in OCI call'. (serverType=`ORACLE8i', serverName=****, userName=****, password=`***', dbname=`')When calling with python I can parse the result easily:
Is there a way to reach similar result using an SQLCreator?
import fme
import fmeobjects
import cx_Oracle
# Template Function interface:
def processFeature(feature):
pass
# Template Class Interface:
class FeatureProcessor(object):
def __init__(self):
pass
def input(self,feature):
try:
# Connect to database.
db_conn = *****
# Get file path and name.
f_path = feature.getAttribute("L_PATH")
f_name = feature.getAttribute("L_NAME")
# Call function.
db_cur = db_conn.cursor()
values = db_cur.callfunc("bddoc_mgr.get_file_status_fme", cx_Oracle.CURSOR, \
[f_path, f_name])
# Convert values.
for value in values:
feature.setAttribute("S_STATUS", value[2])
feature.setAttribute("N_VERSION", value[3])
feature.setAttribute("L_USERID", value[4])
break
finally:
# Disconnect.
try:
db_conn.close()
except:
pass
self.pyoutput(feature)
def close(self):
pass 
