I am trying to create an SP
create procedure proc1 ( IN id number)
select * from housing_all_201506 where ar_id = id;
and then I call this SP through the following statement:
However, I get an error " ORA-06575: Package or function proc1 is in an invalid state.
I can see that proc1 appears under the heading "Procedures" but I can't seem to call it. Could anyone help me with this?
Posting the same question a 2nd time will not help, try to get help on an Oracle forum, this is Teradata territory...