CREATE TABLE [dbo].[dbh_sql_bind_variables_ora]
(
[sql_id] [decimal] (8, 0) NOT NULL,
[variable_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[execution_datatype] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[max_length] [decimal] (8, 0) NOT NULL,
[array_index] [decimal] (8, 0) NULL,
[variable_value] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[dbh_sql_bind_variables_ora] ADD CONSTRAINT [dbh_sql_bind_variables_ora_pk] PRIMARY KEY CLUSTERED ([sql_id], [variable_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_bind_variables_ora] ADD CONSTRAINT [dbh_sql_bind_var_ora_sql_fk] FOREIGN KEY ([sql_id]) REFERENCES [dbo].[dbh_sql_ora] ([sql_id]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[dbh_sql_bind_variables_ora] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_sql_bind_variables_ora] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_sql_bind_variables_ora] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_sql_bind_variables_ora] TO [udmadmin_group]
GO