79140680

Date: 2024-10-30 10:37:06
Score: 2
Natty:
Report link

I may be 3 years late but I think OP is asking about the difference between a stored procedure (create or replace procedure toto is...) and a local (procedure toto is...).

The first one is stored in oracle (and callable from elsewhere since it is stored in oracle, which surely fit your needs), while the other one have a local scope (the anonymous block where you wrote it). So this second syntax can't be on its own somewhere.

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: user28058540