MySQL Forums
Forum List  »  French

need help to define an array in parameter
Posted by: Pierre Veronneau
Date: October 28, 2024 08:18AM

CREATE OR REPLACE PACKAGE "TEST_PKG"
IS

type rec_type is RECORD
(
p_var1 varchar2(1),
p_var2 varchar2(2)
);
type rec_array is varray(50) of rec_type;

PROCEDURE TEST_PROC (
p_proc1 IN VARCHAR2,
p_proc2 IN VARCHAR2
);

END TEST_PKG;

/


CREATE OR REPLACE PACKAGE BODY "TEST_PKG"
IS
PROCEDURE TEST_PROC (
p_proc1 IN VARCHAR2,
p_proc2 IN VARCHAR2,
p_var_type IN rec_array
)
IS

v_nombre NUMBER;
v_var1 VARCHAR2(2);
v_var2 VARCHAR2(2);

BEGIN
v_nombre := 2;
FOR i IN 1 .. v_nombre
LOOP
v_var1 := p_var_type.p_var1(i);
v_var2 := p_var_type.p_var2(i);
END LOOP;

dbms_output.putline('v_var1' || v_var1);
dbms_output.putline('v_var2' || v_var2);


EXCEPTION
WHEN OTHERS
THEN
dbms_output.putline('probleme');

END TEST_PROC;

END TEST_PKG;

/

I'm getting message
[Error] PLS-00302 (18: 36): PLS-00302: Le composant 'P_VAR1' doit être déclaré
[Error] PLS-00302 (19: 36): PLS-00302: Le composant 'P_VAR2' doit être déclaré
[Error] PLS-00302 (22: 21): PLS-00302: Le composant 'PUTLINE' doit être déclaré
[Error] PLS-00302 (23: 21): PLS-00302: Le composant 'PUTLINE' doit être déclaré
[Error] PLS-00302 (29: 19): PLS-00302: Le composant 'PUTLINE' doit être déclaré
[Error] PLS-00323 (11: 11): PLS-00323: Sous-programme ou curseur 'TEST_PROC' déclaré dans les spécifications; doit être défini dans le corps.

Options: ReplyQuote


Subject
Views
Written By
Posted
need help to define an array in parameter
95
October 28, 2024 08:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.