I am passing a parameter (source_table_name
) in procedure
which actually a table_name.
Also, I am declaring a collection type and using source_table_name%rwtype
instead of actual_table_name%rowtype
.
Its throwing an error.
请建议是否有任何变通办法.
CREATE OR REPLACE PROCEDURE PRM_BKUP_TRNSACTION_TABLE_PROC
(
source_table_name IN VARCHAR2,
archive_date_col IN VARCHAR2,
archive_form_date IN VARCHAR2,
archive_to_date IN VARCHAR2
)
AS
--Collection
TYPE source_table_collection IS TABLE OF source_table_name%ROWTYPE; <----(passing proc parameter)
source_data source_table_collection;