All Forums Database
aolympio 25 posts Joined 04/09
08 Jul 2009
Problems when I'm creating a stored procedure

Hi guys!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.Thanks for help,Anderson

Adeel Chaudhry 773 posts Joined 04/08
08 Jul 2009

As clearly defined in the error message .... you need to have CREATE PROCEDURE rights on the database for the user you are using!You (DB admin) can either do that using Teradata Administrator or by using GRANT command! For details refer to the manuals!And also it is a good practice to fully qualify the DB object name e.g. Database1.StoredProcedure1.HTH!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

aolympio 25 posts Joined 04/09
08 Jul 2009

I got access but now I got another error:"5863: Problem encountered during compilation phase of C code."What should I have to resolve this?Thanks,Anderson

You must sign in to leave a comment.