When running the statement 'Call <procedure> (xxx, xxx)' in SQLplus I get an 'ORA-01403: no data found' message. However, if I run the same statement in Toad, I do get this message. Why is this?
Use the command EXEC, instead of CALL, when running the statement in Toad.
EXEC is supported by Toad, but CALL is not in the list of supported commands. In all cases, we try to emulate SQL*Plus but we will not always have the same messages as SQL*Plus. We do our best to emulate the functionality but we rely on our data layer to provide any feedback messages and in this case of the CALL statement we are not receiving any. If you would like to use CALL, I would suggest that you use the Execute in SQLplus feature that is available in Toad. Otherwise I would suggest to use EXEC, since it seems to be giving you the same messages that you are getting from SQLplus.
