When I'm trying to create a stored procedure into, Teradata SQL Assistant, I receive this message error: "SPL1040:E(L6), Invalid definition for stored procedure 'E(3524): The user does not have CREATE PROCEDURE access to database MYDATABASE.' "
This is my script:
CREATE PROCEDURE MyStoredProcedure (IN FIELD1P VARCHAR(50), IN FIELD2P VARCHAR(50))
BEGIN INSERT INTO MY_TABLE(FIELD1 ,FIELD2) VALUES (FIELD1P ,FIELD2P); END;
Ps: FIELD1 and FIELD2 are VARCHAR(50) Type into MY_TABLE table.