The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved
Please file a support request at https://support.tibco.com and our team will have a look at this issue. Thanks, Thomas
I am using the following in a select statement but gets an error:
Lead( "DATETIME#1", 1, 0) OVER (ORDER BY "DATETIME#1") AS "NEXT_DATETIME#2" and received
the error "Failed to execute query: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes:
Note: DATETIME#1 is already defined as DateTime type column in information link and trying to create and populate DATETIME#2 column from the leading rows of DATETIME#1 column values.
Doing this from the SQL environment of the information link.