Hi, I am executing a query through executequery() expression rule. To the q

The nast numbers like as you have, can't be stored in Number(Integer). You can store tem only on Number(Decimal). In CDT too, you need to annotate 'Decimal or Double' for that sepecified column with large number. Thus by you can avoid problems while storing that large numbers in DB.

Regarding XSD annotation refer :forum.appian.com/.../Defining_a_Custom_Data_Type

@mathanp
I don't need to store any number.The scenario is as follows: I need to pass a number(which is timestamp of oracle) and convert into datetime format. For this the number needed to be passed exactly.
executequery("jdbc/AppianPrimaryDS","SELECT TO_CHAR(
FROM_TZ(
CAST(to_date('1-1-1970 00:00:00','DD-MM-YYYY HH24:Mi:SS')+(&ri!epochNumber&/86400000) AS TIMESTAMP)
, '+00:00'
)
AT TIME ZONE '+05:30'
, 'DD-MON-YYYY HH24:Mi:SS')
FROM DUAL")

Change the rule input type to decimal and try the following syntax
executequery("jdbc/AppianPrimaryDS","SELECT TO_CHAR(
FROM_TZ(
CAST(to_date('1-1-1970 00:00:00','DD-MM-YYYY HH24:Mi:SS')+("&ri!epochNumber&"/86400000) AS TIMESTAMP)
, '+00:00'
)
AT TIME ZONE '+05:30'
, 'DD-MON-YYYY HH24:Mi:SS')
FROM DUAL")

@mathanap No, i have already tried it and its not working. Could you please suggest some other way?

Can you please post the error(or) response obtained while executing it?

If you don't mind can you share the database type?

@mathanp sorry for the delay. I came to work today itself after friday. I got the solution. Thanks for the suggestions..