I have just started using Teradata.
I am trying to create a simple Stored Procedure in Teradata 12 server machine in SQL Assiatance using 'dbadmin' user, but i am getting the below error message:
"3927: Response Parcel requested a max byte count less than 256"
Below is the Stored Procedure:
CREATE PROCEDURE MyFirstProc (IN emp_number INTEGER,
IN dept_number INTEGER,
OUT dept_name CHAR(10),
INOUT errstr VARCHAR(30))
INSERT INTO Employee (EmpNo, DeptNo )
VALUES (emp_number, dept_number);
SELECT DeptName INTO dept_name FROM Department
WHERE DeptNo = dept_number;
Please let me know how i can resolve this issue.
Thanks in advance.
small update here: when I increase the fetch size to 100, it works... but I think, it is not a normal behaviour?
That problem is likely to be too difficult to troubleshoot on this forum. We would need to examine the Teradata JDBC Driver debug log in order to determine what is occurring.
If you are a customer, then please open a customer incident. If you are not a customer, then please try upgrading to a newer version of the Teradata Database. The fetch size feature was originally introduced in Teradata Database 13.10, and there were some bugs in the feature in early Teradata Database 13.10 releases like the one that you are using.
Thank you for a fast reply! We will try to get a newer version and double check these problems.