How can I pass arrays to teradata 13 stored procedures?

UDA

How can I pass arrays to teradata 13 stored procedures?

Hi,

    Is it possible to pass an array to a teradata (13) stored procedure?  If I had to do it in oracle, it would look as follows:

create or replace

TYPE T_STR_ARRAY AS TABLE OF varchar2(6);

 PROCEDURE p_AcceptArray( inArrayCdes in T_STR_ARRAY ) IS.....etc

Any help would be greatly appreciated

1 REPLY

Re: How can I pass arrays to teradata 13 stored procedures?

I am trying to create a user defined variable that i can later pass and invoke the names of tables, in SAS we use an &name. to pull it in and %Macro; to mend it and invoke it.  How would I do this in Teradata?

Would I need to create a function like this? 

CREATE FUNCTION input_tables ('TABLE8X ' VARCHAR(20),  'TABLE_8X' VARCHAR(20), 'TABLE_SESSION_8X' VARCHAR(20), 'TABLERL_8X' VARCHAR(20) )

RETURNS  VARCHAR(20)

LANGUAGE C

NO SQL

PARAMETER STYLE SQL

EXTERNAL;

appreciate the help!