Stored proc in Teradata gives an error "Invalid State"

Database

Stored proc in Teradata gives an error "Invalid State"

Hi,

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:

call proc1(156170507);

 

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?




1 REPLY
Junior Contributor

Re: Stored proc in Teradata gives an error "Invalid State"

Posting the same question a 2nd time will not help, try to get help on an Oracle forum, this is Teradata territory...