Stored Procedure Creation and Execution Questions
I'm very new to oracle and i'm having problems creating and executing a stored procedure. This is my code:
----------------------------------------------------------------
create or replace
PROCEDURE UpdateStateCity(pStateName IN VARCHAR2)
AS
BEGIN
select UpdateStateCity.pStateName from dual
END UpdateStateCity;
----------------------------------------------------------------
After running this I get this message
Warning: execution completed with warning
PROCEDURE UpdateStateCity(pStateName Compiled.
What in my code is causing this error?
Where can I go to find out the warning?
Next I run this line to see if it works
execute UpdateStateCity('NewYORK');
it returns:
Error starting at line 1 in command:
execute UpdateStateCity('NewYORK');
Error report:
ORA-06550: line 1, column 7:
PLS-00905: object JWARRA.UPDATESTATECITY is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
any help would be very apprceiated.
Thank You