Re: Calling stored procedure with Pro*C

jphoward_at_amoco.com (John Howard) wrote: ...
>EXEC SQL EXECUTE
> BEGIN
> TEST.INS(:in_text, :numeric, :in_date, :err_code);
> END;
>END-EXEC;

 ..
>But I get an error from the pre-compiler :-
>
> TEST.INS(:in_text, :numeric, :in_date, :err_code);
>.................................1
>(1) PCC-S-02201, identifier 'TEST.INS' must be declared
 ..
>Sorry if this is an RTFM error but it's late Friday afternoon and my brain
>is dead.

If you haven't already figured it out yourself, When you call TEST.INS(....) in the Pro*C program, it means that TEST is either the name of the schema (I guess you can also say Oracle user) that has the ownership of the standalone procedure called INS or TEST is the name of a package which has a procedure called 'INS' that you can call. If TEST doesn't qualify for either of these cases, then you should get the error you described.

Murthy. Received on Fri Aug 11 1995 - 00:00:00 CEST