facing issue as Cannot describe stored procedure arguments
Hi Team,
we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required.
For reference we are adding the Procedure for reference.
- FUNCTION sf_get_var_text( as_translation_id IN translation.translation_id%TYPE
- , atab_var IN tab_var
- , as_language_code IN translation.language_code%TYPE DEFAULT 'EN')
- RETURN VARCHAR2
- AS
- ln_index NUMBER(2);
- ls_translation_text translation.translation_text%TYPE;
- ls_searchvar VARCHAR2(2000);
- ln_start NUMBER;
- ln_end NUMBER;
- ls_var_name VARCHAR2(2000);
- ls_var VARCHAR2(2000);
- BEGIN
- ls_translation_text := sf_get_text( as_translation_id, as_language_code);
- FOR ln_index IN atab_var.FIRST..atab_var.LAST LOOP
- ls_var := atab_var(ln_index);
- ls_searchvar := '{@'||LTRIM(TO_CHAR(ln_index, '00'));
- ln_start := INSTR(ls_translation_text, ls_searchvar);
- WHILE ln_start > 0 LOOP
- ln_end := INSTR(ls_translation_text, '}', ln_start);
- IF ln_end > 0 THEN
- ln_end := ln_end + 1;
- END IF;
- ls_searchvar := SUBSTR(ls_translation_text, ln_start, ln_end - ln_start);
- --Check if the the must be found in ref_code_master
- ln_start := INSTR(ls_searchvar, '[') + 1;
- ln_end := INSTR(ls_searchvar, ']', ln_start);
- ls_var_name := SUBSTR(ls_searchvar, ln_start, ln_end - ln_start);
- IF LENGTH(ls_var_name ) > 0 THEN
- --Found so translate the given code
- ls_var := sf_get_descr_from_table( ls_var_name, ls_var, as_language_code);
- END IF;
- ls_translation_text := REPLACE(ls_translation_text, ls_searchvar, ls_var);
- ls_var := atab_var(ln_index);
- ls_searchvar := '{@'||LTRIM(TO_CHAR(ln_index, '00'));
- ln_start := INSTR(ls_translation_text, ls_searchvar );
- END LOOP;
- END LOOP;
- RETURN ls_translation_text;
- END sf_get_var_text;
atab_var is a user defined type as below