Re: Calling stored procedure with Pro*C

> jphoward_at_amoco.com (John Howard) writes:
> I'm trying to call a stored porc from a Pro*C program.
> From what I can tell form the manuals this should work :-
>
> 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
>
> TEST.INS(:in_text, :numeric, :in_date, :err_code);
> ............................1
> (1) PCC-S-02000, Statement ignored
>
> Any clues ?
>
> Sorry if this is an RTFM error but it's late Friday afternoon and my brain
> is dead.
>
> Thanks in advance,
> John
>>>>

You didn't mention your Pro*C pre-compiler switches.

To use PL/SQL in Pro*C, you must specify sqlcheck=semantics (or sqlcheck=full which are equivalent). You must also specify user=uname/pword.

Make sure you give the Pro*C compiler a username/password that has access to your stored procedure.

Also, TEST.INS() must exist in the database either as a package.procedure or owner.procedure.

Will Kooiman
Computer Systems Authority Received on Sat Aug 12 1995 - 00:00:00 CEST