Stored proc in Teradata gives an error "Invalid State"

General

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

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

Hi Marlon Brando.

Get back to the Oracle forums where you belong ;-)

Cheers.

Carlos.