Create a stored procedure in Oracle SQL and call it .Net
Create or replace procedure getemploye(Id as number)As
Result as varhcar2(1000)
Select Id,Region,Country into result from emplooyee where id=id;
DBms_Out.Put_Line(Result);
End getemploye;
Error
Pl-sql:ORA-00947:not enough values
06550:Encountered the symbol "" When expecting
One of the following
:=.(@%;
While executing the procedure I got above
Error