Does anyone know of any Oracle-supplied PL/SQL procedure (in its *many* available scripts and add-ons) that can perform a basic sprintf?
For those that don't know, the sprintf function would allow the following:
sprintf (ResultingString, "Error: %s (%d) on line %d", l_ErrorText, l_ErrorID, l_LineNumber)
ResultingString might then be:
"Error: Bad Employee ID (-20010) on line 5"
I'd like to know if the functionality exists before 'rolling my own'
Click Here to Expand Forum to Full Width