do you have any idea about it?
Expand|Select|Wrap|Line Numbers
- declare
- c1 varchar2(80);
- c2 varchar2(80);
- begin
- execute immediate 'select col2 from table1 where col1=:c1'
- into c2 using 'AAA';
- end;
- /
here is the definition of table:
Expand|Select|Wrap|Line Numbers
- CREATE TABLE TABLE1
- (
- COL1 VARCHAR2(80 BYTE),
- COL2 VARCHAR2(80 BYTE),
- VAL VARCHAR2(80 BYTE)
- )
and the data contained by the table:
Expand|Select|Wrap|Line Numbers
- Insert into TABLE1
- (COL1, COL2)
- Values
- ('AAA', '1');
- Insert into TABLE1
- (COL1, COL2)
- Values
- ('BB', '2');
- Insert into TABLE1
- (COL1, COL2)
- Values
- ('C', '3');
- COMMIT;
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 5