Home » SQL & PL/SQL » SQL & PL/SQL » select data INTO variable "No data found error"
select data INTO variable "No data found error" [message #45321] |
Wed, 03 March 2004 05:56  |
raj_oracle
Messages: 5 Registered: March 2004
|
Junior Member |
|
|
I am trying to write the query inside a procedure as "select empId into id_var where ........".This query giving me teh error as "No Data found". Probably for any condition the select query returning the null value and its trying to insert into id_var variable.So how to handlle this kind of situation , when u can expect the null value also to return??Can we do something so that if null value also returns , the query will execute fine.
�Pls someone help ...
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Jun 03 02:49:32 CDT 2025
|