All Forums Tools
darnost 5 posts Joined 08/11
15 Nov 2012
Teradata Studio cannot run Stored procedures

Hi, we would like to use TD studio (version 14.01) which looks like very interesting and powerfull tool. However it seems that the tool does not support stored procedures. At least, we haven't been able to run any stored procedure yet. The Studio returns an error message:
"Executed as a single statement. Failed [5510 : HY000] Invalid session mode for procedure execution. "
It looks like a problem is not in the tool but in a setup of the tool Could anyone tell us what we should do to fix this?
Thanks in advance.
Dan
 

CarlosAL 512 posts Joined 04/08
16 Nov 2012

Dan:
RTFM:

5510 Invalid session mode for procedure execution.
Explanation: The session mode within which the CALL SQL is submitted is different than the one in which the stored procedure was created. A stored procedure created in ANSI mode cannot be executed in Teradata mode and vice versa

Cheers.
Carlos.

CarlosAL 512 posts Joined 04/08
16 Nov 2012

I forgot to mention:
To change the TD Studio session mode :
->Connection->JDBC Connection Properties->TMODE
Cheers.
Carlos.

darnost 5 posts Joined 08/11
18 Dec 2012

Thanks!
Dan

You must sign in to leave a comment.