Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

fdmAPI.executePLSQL returns None

edited Nov 14, 2016 8:47AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered ✓

Hi Experts,

I'm trying to execute a custom script, within i try to execute a select query.

The statement is simple:

RS = fdmAPI.executePLSQL("SELECT DATAKEY FROM TDATASEG")

while (RS.Next()):

   var1 = RS.getString("DATAKEY")

fdmAPI.showCustomMessage("Query select: "+str(var1))

The result is an error:

    while (RS.next()):

AttributeError: 'NoneType' object has no attribute 'next'

Can you help me plz

Thank you,

Best regards,

Hassan

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center