Re: Trouble calling stored procedure from Pro*C

Hello again,

I found the solution to my own problem. For the command-line parameters to proc I had SQLCHECK=SEMANTICS, but I didn't have userid=name/passwd. This caused the login to fail, and subsequent semantics to fail. Hope this helps someone someday.

Paul Cluiss
Dallas, Texas

paul cluiss wrote:

> Hello, everyone.
>
> I know this error has already been disgust a couple of times at least,
> but I'm getting it from the Pro*C compiler, although SqlPlus can execute
> 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
> (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
> called "oraclient" under my account, and I can run it from SqlPlus from
> my account, so I don't think this is a security issue. This has got me
> stumped. Any help would be greatly appreciated. Thanks.
>
> Paul Cluiss
> Dallas, Texas
Received on Fri Jul 16 1999 - 00:27:51 CEST