Trouble calling stored procedure from Pro*C

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Thu, 15 Jul 1999 08:44:42 -0500
Message-ID: <378DE5CA.CD5DE64_at_intervoice.com>

[Quoted] Hello, everyone.

I know this error has already been disgust a couple of times at least, [Quoted] but I'm getting it from the Pro*C compiler, although SqlPlus can execute [Quoted] the stored procedure correctly. Here's the error from Pro*C when I attempt to compile oraclient.pc:

                BEGIN oraclient.validate_card(:theAuthCode, :thePin,

:vFlag);

......................1

(1) PCC-S-02201, identifier 'ORACLIENT.VALIDATE_CARD' must be declared

                BEGIN oraclient.validate_card(:theAuthCode, :thePin,

:vFlag);

......................1

[Quoted] (1) PCC-S-02000, Statement ignored

Semantic error at line 136, column 3, file oraclient.pc:

                BEGIN oraclient.validate_card(:theAuthCode, :thePin,

:vFlag);

................1

(1) PCC-S-02346, PL/SQL found semantic errors

• Error exit code 1

Stop.

Oddly enough, I can call this stored procedure from my test script in SqlPlus, and it works fine. I created this procedure inside a package [Quoted] called "oraclient" under my account, and I can run it from SqlPlus from [Quoted] my account, so I don't think this is a security issue. This has got me [Quoted] stumped. Any help would be greatly appreciated. Thanks.

Paul Cluiss
Dallas, Texas Received on Thu Jul 15 1999 - 15:44:42 CEST