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:
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) )
PARAMETER STYLE SQL
appreciate the help!