Setting the DBPROMPT= option to "YES" in the LIBNAME statement causes SAS In-Database processing to fail and produces an error similar to the following:
ERROR: Error during in-database processing.
An error similar to the following might also occur:
ERROR: General error ORA-01017: invalid username/password; logon denied.
A possible workaround for this issue is to use the DEFER=NO option in addition to the DBPROMPT=YES option in the LIBNAME statement. Doing this gives you the benefit of SAS In-Database processing even when DBPROMPT=YES is specified.
If DEFER=NO will not work for your situation, try adding the SQLGENERATION=NONE option in the LIBNAME statement so that the code does not attempt to try SAS In-Database processing.