Bonjour,
j'ai un petit problème avec une requete PL/SQL:
A la compilation, je recois l'erreur
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;
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.
Partager