tags for listings. 2. I have on idea what your version number is. 3. I'm not going to read a kilometer of code to try to find an issue ... create a simple test case that recreates the issue. 4. You didn't think the error important enough to post so I've no idea what is actually going on. Please fix this thread and likely I or someone else will be able to help you. But why are you using DBMS_SQL and not native dynamic SQL? That is really my first question.
Augustine Vinish wrote:There is nothing in the code you've posted that would directly cause that error. Therefore, it would suggest that the issue is in one of the functions that is being called in the query, but as we don't have your code, we cannot help.
Hi Team ,
The below inesrt query returns an error message " exact fetch returns more than one row " . How can I found the insert query statement on the below query in the DBMS_SQL.PARSE ?