如果是 oracle return 有01000是警告的意思 100，1405，1403没有看到过 select * from tablename where id=11 你可以用cursor来得到返回的值 delete tablename where id=11 不会放回，但你可以从处理的行数来判断处理的怎么样! 如果是用fetch，请用变量从cursor中得到值.
ORA-01403 no data foundCause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query. Action: Terminate processing for the SELECT statement.ORA-01405 fetched column value is NULLCause: The INTO clause of a FETCH operation contained a NULL value, and no indicator was used. The column buffer in the program remained unchanged, and the cursor return code was +2. This is an error unless you are running Oracle with DBMS=6, emulating version 6, in which case it is only a warning.Action: You may do any of the following: Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution. Use an indicator to record the presence of the NULL. You probably should use this option when you want a specific action to be taken when a NULL arises. Revise the cursor definition so that no columns possibly containing NULL values are retrieved. ORA-00100 no data foundCause: An application made a reference to unknown or inaccessible data.Action: Handle this condition within the application or make appropriate modifications to the application code.
100，1405，1403没有看到过
select * from tablename where id=11 你可以用cursor来得到返回的值
delete tablename where id=11 不会放回，但你可以从处理的行数来判断处理的怎么样!
如果是用fetch，请用变量从cursor中得到值.
return v_name;
exception
when others then
return sqlcode||sqlerrm;--RA-01403: no data found