Oracle ERROR : INVALID SQL STATEMENT ERROR

Question

I have maked an stored procedure but I cannot execute the stored procedure I dont know what the problem is.

Source code:

Create or replace procedure land_naam(klantnummer_input in VARCHAR2
, verzendland_output out VARCHAR2)

AS 

BEGIN

SELECT land into verzendland_output from klanten 

WHERE klantnummer = klantnummer_input;

END land_naam;

First I create the procedure without any error.

Then if I want to execute it I run the code

Execute land_naam;

after that I get the error :

ORA-00900: invalid SQL statement

What can i do to solve this problem? The procedure The error statement

from what I can tell, you're specifying klantnummer_input as an input parameter. You have to pass a value for it Execute land_naam(some_input_value) — Daniel Farrell
What do you think (klantnummer_input in VARCHAR2 , verzendland_output out VARCHAR2) mean? — Ken White
Still getting the same error If I pass value for it I tryed execute land_naam('S'); — Samet Selvi

Mark Soriano Mark Soriano · Accepted Answer · 2018-11-01T06:53:57

Modify your code to something like this:

Create or replace procedure land_naam(klantnummer_input in VARCHAR2)
AS 
verzendland_output VARCHAR2(2000);
BEGIN
SELECT land into verzendland_output from klanten 
WHERE klantnummer = klantnummer_input;
END land_naam;

When executing the procedure, since you have an input parameter, provide one.

e.g. EXECUTE land_naam('S');

Oracle ERROR : INVALID SQL STATEMENT ERROR

2 Answers