When i call a stored procedure getting message 'CALL Failed. HY000:' no error code displayed. I am migrating oracle code to Teradata.I am new to stored procedures. Code is as below....
Please share a proper code with the proper concerns you have.
Not able to understand whats your requirement and where's the problem.
This is my call statement 'CALL DS.usp_ins_orderview('20110918','20110919',30)', records do get inserted in the table but after call comeltes i get message as 'CALL Failed. HY000:......' i want to know why this message is coming and also the sqlstate T0001 is not displayed.I have pasted the code as is
You expect reading unformatted code which is mainly commented out?
Of course you get an error, you throw it in your code using SIGNAL.