new to oracle How to execute Stored Procedure

[praneeth ram]

hi all, i have the bellow stored procedure how to execute it.

CREATE OR REPLACE PROCEDURE myproc1(x in varchar,y out varchar)
  IS
  BEGIN
  y :=concat(x,1);
  DBMS_OUTPUT.PUT_LINE(y);
  END;
/

> Procedure created.

No i am trying to run it
> exec myproc1 (john)

i am getting the bellow error

*

ERROR at line 1:
ORA-06550: line 1, column 16:
PLS-00201: identifier 'JOHN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Can any one help me how to run the above one.
Thanks,
Praneeth

[Ninad Kulkarni]

Try to execute below code and let us know

CREATE OR REPLACE PROCEDURE myproc1(x in varchar2,y out varchar2)
  IS
  BEGIN
  y :=concat(x,1);
  DBMS_OUTPUT.PUT_LINE(y);
  END;
/

[praneeth ram]

nothing great same error we are getting.

could you please post the procedure code and execution command.

Thanks,
Praneeth

[Fatih Keles]

PLS-00201: identifier 'JOHN' must be declared
a variable named john is looked for but can not be found.

This one will work.

exec myproc1 ('john')

[Ninad Kulkarni]

@praneeth
As explained by Fatih you need to send varchar2 type parameter in procedure

[praneeth ram]

Hi Ninad Kulkarni,Fatih Keles I got the solution. please find it bellow. thanks for replying.

Step:1

SQL>create or replace procedure myproc1(x in varchar,y out varchar)
	is
	begin
	y:=concat(x,1);
	DBMS_OUTPUT.PUT_LINE(y);  
	END;  
	/
Procedure created. 

After creation of the above stored procedure. Now declare one bind variable in the sql prompt.

Step:2

sql> var d varchar2(9);

Now call the StoredProcedure by passing the "name" and the bind variable.

Step:3

sql> exec myproc1('sai',:d)

PL/SQL procedure successfully completed.
After execution of the above command the output is stored in bind variable. Now print the bind variable

Step:4

sql> print:d

*****output********
D
---------------
sai1

So Finally i got the expected solution for the stored procedure. Ninad Kulkarni,Fatih Keles thanks for replying for my query.