I have a procedure without a parameter:
create or replace procedure test(a out number) is begin a:=1; dbms_output.put_line(a); end;
How do I execute this procedure? When I give these commands:
execute test(1); execute test()
this gives an error.
As with any of these problems, the exact error message is critical in determining the problem, and thus, the resolution.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.