IN ORACLE MILIEU …

Beyond Knowledge

Tag Archives: plsql

Avoiding “no data found” : Tips

3 Comments Posted by on April 29, 2011

Some time we face issue about no data found depending on selection criteria. And when this happens in PLSQL procedure we get annoying error ORA-01403: No data found and execution stops. One way to get around this error is to add exception block in our PLSQL procedure as shown below EXCEPTION WHEN NO_DATA_FOUND THEN <Take Action> [...]

ORA Errors, Oracle Database 11g , , ,

Using TABLE_TO_COMMA in PLSQL

2 Comments Posted by on March 13, 2008

Some times the situation arises where we want to output the result from the table as a comma separated string. This situation can be answered using many methods. The most efficient method, however, is using TABLE_TO_COMMA procedure of DBMS_UTILITY package. Below is the example that I encountered. set echo on serveroutput on declare cursor c1 [...]

Oracle Database 10g ,

Follow

Get every new post delivered to your Inbox.

Join 156 other followers