Stored Procedure Compile Errors

Database

Stored Procedure Compile Errors

Hi,

I have a complex Stored Procedure.

When I compile it using teradata SQL Assistant ( ODBC) it works & runs fine.

However , when I use the same piece of code and run it on Teradata Studio Express(JDBC) it doesnt.

I get the following error :

Failed [5526 : HY000] Stored Procedure is not created/replaced due to error(s).{Nested Failure Msg [5526 : HY000]

JDBC Connection Parameters :

TMODE=TERA

CHARSET=ASCII

Is there anythign else I can do?

Thanks.

Shraddha.

1 REPLY
Enthusiast

Re: Stored Procedure Compile Errors

Not sure whether you have seen the below article on Studio Express -

http://developer.teradata.com/tools/articles/teradata-studio-express

If you check the discussion at the end of the article, someone already mentioned the similar issue you are facing and the author responded saying they would look into it to get it fixed. The post is around 1 year old, so not sure whether they really fixed it or not after that.