我已經創建了嵌套表，我想為它們分配專案。但是當我嘗試這樣做時，我得到了一個錯誤
Error at line 27, 28: PLS-00382: expression is of wrong type
而27、28行是用assign。我已經宣告了一些引數：
DECLARE
clubIdFirst NUMBER;
clubIdSecond NUMBER;
TYPE clubsIdsArray IS TABLE OF NUMBER;
nestedclubsIdsArray clubsIdsArray:=clubsIdsArray()
BEGIN
//assign values to clubIdFirst and clubIdSecond trying assign them to table
nestedclubsIdsArray .EXTEND(2);
nestedclubsIdsArray := clubIdFirst;
nestedclubsIdsArray := clubIdSecond;
為什么會發生？
uj5u.com熱心網友回復：
您忘了說要為哪個元素分配值（參見第 11 和 12 行），例如：
SQL> DECLARE
2 clubIdFirst NUMBER;
3 clubIdSecond NUMBER;
4
5 TYPE clubsIdsArray IS TABLE OF NUMBER;
6 nestedclubsIdsArray clubsIdsArray:=clubsIdsArray();
7
8 BEGIN
9 --assign values to clubIdFirst and clubIdSecond trying assign them to table
10 nestedclubsIdsArray .EXTEND(2);
11 nestedclubsIdsArray (1):= clubIdFirst;
12 nestedclubsIdsArray (2):= clubIdSecond;
13 end;
14 /
PL/SQL procedure successfully completed.
SQL>
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/472543.html