SAP Knowledge Base Article - Preview

2556862 - Table Function when run directly from SQL editor fails with ' invalid number: [6930] attribute value not a number'

Symptom

When you execute a a table function, which uses a date variable whose value is initialized to NULL, from the SQL editor as follows:

--------------------------------------------------------------------

DO BEGIN
DECLARE AS_OF_DATE DATE = NULL;
SELECT *
FROM <table function  qualified name>;
END;

-----------------------------------------------------

This gives an error as follows:

---------------------------------

Could not execute 'DO BEGIN DECLARE AS_OF_DATE DATE = NULL= ...' in 6.157 seconds .
SAP DBTech JDBC: [339]: invalid number: "SAPSUPPORT"."DO": line 7 col 1 (at pos 233), line 2 col 9 (at pos 18), line 3 col 9 (at pos 68), line 5 col 9 (at pos 174): [339] (range 3) invalid number exception: invalid number: search table error: <table function>: line 39................................... line 31 col 5 (at pos 1718): [339] (range 3) invalid number exception: invalid number: [6930] attribute value is not a number (please check lines: 31, 52, 72, 91, 114) (please check lines: 39, 78, 124, 141, 147, 153, 168, 298)
Could not execute 'SELECT * FROM ...'

---------------------------------------------


Read more...

Environment

SAP HANA PLATFORM 1.0

Product

SAP HANA 1.0, platform edition

Keywords

NULL date value, empty date , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.