Tearadata Stored procedure problem

Database
Enthusiast

Tearadata Stored procedure problem

Hi Friends,

I executed the below 3 querys pertaining to stored procedure and it worked well in my TD version 13. The same query while i executed in TD 14 it threw me with Error 3706 Invalid SQL statement while executing the CREATE PROCEDURE query. Not able to figure out where the mess is. Can anyone help me out on this please ASAP?

CREATE MULTISET VOLATILE TABLE US_STATES , NO JOURNAL, NO LOG,NO FALLBACK

(

STATE_NAME VARCHAR(13),

STATE_ABBR CHAR(2),

STATE_CAPITAL VARCHAR(13),

STATE_CITY VARCHAR(13)

)

PRIMARY INDEX(STATE_NAME)

ON COMMIT PRESERVE ROWS

;

CREATE PROCEDURE US_STATE_1()

BEGIN

INSERT INTO US_STATES VALUES('Alabama','AL','Montgomery','Birmingham');

END;

call US_STATE_1();

1 REPLY
Enthusiast

Re: Tearadata Stored procedure problem

CREATE PROCEDURE SANDBOX.US_STATE_1()

BEGIN

INSERT INTO US_STATES VALUES('Alabama','AL','Montgomery','Birmingham');

END;

SEL * FROM DBC.DBCINFO

call SANDBOX.US_STATE_1();

This works good. I I just added database name while creating the proc

Also Please check if you have any special characters while executing the create proc statement