Bonjour,

j'ai un petit problème avec une requete PL/SQL:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
BEGIN
DECLARE
  noCurrencyValue  EXCEPTION ;
  TYPE errorLine IS RECORD (REPORTING_ENTITY_ID 	TEMP_COPS_UPLOAD_AUTO.REPORTING_ENTITY_ID%TYPE,
			    LEGAL_ENTITY_ID 		TEMP_COPS_UPLOAD_AUTO.LEGAL_ENTITY_ID%TYPE,
			    OPERATING_ENTITY_ID 	TEMP_COPS_UPLOAD_AUTO.OPERATING_ENTITY_ID%TYPE,
			    BILL_TO_CUSTOMER_ID 	TEMP_COPS_UPLOAD_AUTO.BILL_TO_CUSTOMER_ID%TYPE,
			    SHIP_TO_CUSTOMER_ID 	TEMP_COPS_UPLOAD_AUTO.SHIP_TO_CUSTOMER_ID%TYPE,
			    FINAL_DEST_CUSTOMER_ID 	TEMP_COPS_UPLOAD_AUTO.FINAL_DEST_CUSTOMER_ID%TYPE,
			    ITEM_ID 			TEMP_COPS_UPLOAD_AUTO.ITEM_ID%TYPE) ;
  TYPE errorTable IS TABLE OF errorLine ;
 
  BEGIN
 
SELECT REPORTING_ENTITY_ID, 
            LEGAL_ENTITY_ID,    
            OPERATING_ENTITY_ID,       
            BILL_TO_CUSTOMER_ID,
            SHIP_TO_CUSTOMER_ID,
            FINAL_DEST_CUSTOMER_ID,
            ITEM_ID 
	 INTO errorTable
     FROM TEMP_COPS_UPLOAD_AUTO 
     WHERE CURRENCY_ID IS NULL ;
 
 
     IF	(errorTable IS NOT NULL) THEN
  		RAISE noCurrencyValue ;
     END IF ;
   END ;	 
END;
A la compilation, je recois l'erreur

PLS-00321: expression 'ERRORLINE' is inappropriate as the left hand side of an assignment statement

sur la ligne INTO errorTable

D'ou vient l'erreur ? d'une mauvaise utilisation du type TABLE ?

Merci pour toutes réponses.