Invalid session mode error for Store Procedure

Database
Enthusiast

Invalid session mode error for Store Procedure

Hi,

Need an urgent help. I am trying to create a SP in Tera mode but it is giving Invalid Session mode error. When I am creating the SP with ANSI mode it is getting created, but while executing the SP using UNIX script, I am getting the same error:Invalid Session Mode.

Please help.

Thanks.

1 REPLY
Junior Contributor

Re: Invalid session mode error for Store Procedure

A SP must be executed in the same session mode used during creation.

You can set the session mode explicitly, e.g.

BTEQ -> .SET SESSION TRANSACTION BTET/ANSI"

ODBC -> Options

.NET -> Advanced tab

Dieter