Today just learning oracle programming, with the idea knocked at, a running error is reported as shown in figure, using PLSQL developer will not appear this kind of problem, also don't know what a situation, where if I didn't set well, sorry ~

CodePudding user response:

Code, don't shot!

CodePudding user response:

Select * to select specific fields,
To estimate the problem here,

CodePudding user response:

Code stick:

DECLARE
V_pricetable T_PRICETABLE % ROWTYPE; - price line object
CURSOR cur_pricetable (v_ownertypeid NUMBER) IS the SELECT *
The FROM T_PRICETABLE
WHERE ownertypeid=v_ownertypeid; - define the cursor
The BEGIN
The OPEN cur_pricetable (2); - open the cursor
LOOP
The FETCH cur_pricetable INTO v_pricetable; - to extract the cursor to the variable
EXIT the WHEN cur_pricetable % NOTFOUND; - when the cursor to the last line below exit loop
Dbms_output. Put_line (' price: '| | v_pricetable. Price | |' tonnage: '| | v_pricetable. Minnum | |' - '| | v_pricetable. Maxnum);
END LOOP;
The CLOSE cur_pricetable; - close the cursor
The END;


After the operation problems:

[65000] [6550] ORA - 06550: line 1, column 8:
PLS - 00103: a symbol "" when need to be one of the following:
The begin function
Package pragma procedure subtype type use & lt; The an identifier>
Form the current cursor
Symbol "" is ignored,
ORA - 06550: line 3, 58 columns:
PLS - 00103: a symbol "" when need to be one of the following:
from