Teradata Studio cannot run Stored procedures

Tools
Enthusiast

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

Tags (1)
3 REPLIES
Junior Supporter

Re: Teradata Studio cannot run Stored procedures

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.

Junior Supporter

Re: Teradata Studio cannot run Stored procedures

I forgot to mention:

To change the TD Studio session mode :

->Connection->JDBC Connection Properties->TMODE

Cheers.

Carlos.

Enthusiast

Re: Teradata Studio cannot run Stored procedures

Thanks!

Dan