Hi,
If anyone faced this issue:
RDBMS code 5510: Invalid session mode for procedure execution
Here is the solution:
Although the Teradata API stage was not designed to invoke Teradata macros, stored procedures, and user-defined functions, it is possible to invoke such objects with the "User-defined SQL" option. However, there are several restrictions when invoking these objects from the Teradata API stage.
The Teradata API stage only connects in ANSI transaction mode, so it can only call procedures that were compiled in ANSI transaction mode. Attempting to invoke a stored procedure that was compiled in Teradata transaction mode will return an error that says, "Invalid session mode for procedure execution".
Please refer to to Teradata DBA for more information on this regards.
Cheers
RDBMS code 5510: Invalid session mode for procedure ...
Moderators: chulett, rschirm, roy
RDBMS code 5510: Invalid session mode for procedure ...
Not only thoughts, but a little bit of experience.